Formula Question

[David M]

Hello All,

Okay..check out this formula

=IF(ISERROR(VLOOKUP(M4,Test,10,FALSE)),"",VLOOKUP
(M4,Test,10,FALSE))

What this does is say okay look at this number in row M4
then look through this named range called test and bring
me back the date....what it does is if the cell in the
named range is blank, it returns a default date of 1/0/00,
or 1/0/1900...I would like to say, IF the cell referenced
is blank, then return "" don't guve me the default 1/0/00
Thanx

David

 

[Mark Graesser]

Hi David
I posted an answer under your other thread

Good Luck
Mark Graesse
(e-mail address removed)
Boston MA

 

[D.M]

This formula does work but it returns the N/A value to the
destination cell if that cell is blank....so for the
problem of the default retun, it is great but I need to
solve the N/A return value...

D

-----Original Message-----
Hi David,
You can make your condition into an OR statement and

check if it is an error or a zero.