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