vlookup formula, if match found = specific date otherwise leave blank

[Katherine Falin]

Let me start by saying, I'm new to formulas. I need a vlookup formula to find policy numbers matches. If a match is found then insert a specific date "8/22/2014". If no match is found, leave cell blank. A friend at work gave me this one to try. =IF(VLOOKUP(K3,'Eligible Pol Remailed 8.22'!J:J,1,FALSE)=TRUE,"","8/22/2014")
The formula will insert the date, but I am still receiving the NA error message. Suggestions?

 

[Aladin Akyurek]

Let me start by saying, I'm new to formulas. I need a vlookup formula to find policy numbers matches. If a match is found then insert a specific date "8/22/2014". If no match is found, leave cell blank. A friend at work gave me this one to try. =IF(VLOOKUP(K3,'Eligible Pol Remailed 8.22'!J:J,1,FALSE)=TRUE,"","8/22/2014")
The formula will insert the date, but I am still receiving the NA error message. Suggestions?

Try...

=IF(ISNUMBER(MATCH(K3,'Eligible Pol Remailed 8.22'!J:J,0)),"8/22/2014"+0,"")

 

[Momentman]

Welcome to the forum

Have you tried like this?

=IF(ISNA(VLOOKUP(K3,'Eligible Pol Remailed 8.22'!J:J,1,FALSE))=TRUE,"","8/22/2014")

 

[madaknarf]

=IF(ISERROR(VLOOKUP(K3,'Eligible Pol Remailed 8.22'!J:J,1,FALSE)),"","8/22/2014")

This will evaluate the vlookup and if it return's "#N/A" then it leaves the cell blank otherwise the date will be inserted.

 

[Katherine Falin]

Thanks for all the great responses. I tried this one =IF(ISNUMBER(MATCH(K3,'Eligible Pol Remailed 8.22'!J:J,0)),"8/22/2014"+0,"") and it worked perfectly. Since I have several other formulas to work into this spreadsheet, I will definitely refer back to this thread. Thanks again!

 

[Aladin Akyurek]

Thanks for all the great responses. I tried this one =IF(ISNUMBER(MATCH(K3,'Eligible Pol Remailed 8.22'!J:J,0)),"8/22/2014"+0,"") and it worked perfectly. Since I have several other formulas to work into this spreadsheet, I will definitely refer back to this thread. Thanks again!

You are welcome.