Vlookup returns bad date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I am using a Vlookup to return a date, if the date exists.
Problem = if a date does not exist, I get a return value of 1/0/00
I want it to return an empty cell. How?
You guys are great! Thanks for being here
 
Hi! I am using a Vlookup to return a date, if the date exists.
Problem = if a date does not exist, I get a return value of 1/0/00
I want it to return an empty cell. How?
You guys are great! Thanks for being here
Click to expand...

=IF(ISERROR(VLOOKUP(lookup value,lookup table,column
index,FALSE)),"",VLOOKUP(lookup value,lookup table,column
index,FALSE))

Ken Johnson
 
This is the existing formula I have... sorry, but how do I use the one you
gave with this?
=IF(ISERROR(VLOOKUP($B57,'Option Listing- From
Inception'!$A:$AB,10,FALSE)),"",VLOOKUP($B57,'Option Listing- From
Inception'!$A:$AB,10,FALSE))
 
=if(vlookup(...)="","",vlookup(...))

but if you want to add that check:
=if(isna(vlookup(...)),"no match",if(vlookup(...)="","",vlookup(...))))

Change "no match" to whatever you want to see instead of #n/a.

The cell won't actually be empty, but it will look blank.
 
Back
Top