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

On Sep 21, 6:54 am, slrog123
wrote:
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

=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,'Opti on Listing- From
Inception'!$A:$AB,10,FALSE))

"Ken Johnson" wrote:

On Sep 21, 6:54 am, slrog123
wrote:
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

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

Ken Johnson

=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.



slrog123 wrote:

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

--

Dave Peterson