IF Statement Help

[D.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

DM

 

[Guest]

Hi David
I posted the following under your previous thread

*****************************************

Hi David
You can make your condition into an OR statement and check if it is an error or a zero

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

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

 

[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,
I posted the following under your previous thread.

******************************************

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

check if it is an error or a zero.

 

[Guest]

Hi David
The second formula in the OR statement was causing it to crash out when M4 was blank. Change the formula to

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

This should do the trick

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

----- D.M wrote: ----

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

-----Original Message----
Hi David
I posted the following under your previous thread
You can make your condition into an OR statement and

check if it is an error or a zero