Blank Cell

[Missile]

using the following formula in sheet 1 Cell K80 (formatted as Date);
=IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE))
How do I change the formula to have cell K80 blank and not a zero if their
is no data in Data range column 20.

Thanks

 

[ozgrid.com]

=IF(OR(ISBLANK(A60),VLOOKUP(A60,Data,20,FALSE)=0),"",VLOOKUP(A60,Data,20,FALSE))

 

[Jacob Skaria]

Try

=IF(A60<>"",
IF(ISNA(VLOOKUP(A60,data,20,0)),"",
IF(VLOOKUP(A60,data,20,0),VLOOKUP(A60,data,20,0),"")),"")

 

[Missile]

Thanks Dave, that worked for that cell, but when I applied it to all other
cells required in Sheet 1 Column K I now get a #N/A error where the
corrosponding cell in Column A is blank, with original formula I did not get
that error.
Any suggestions ?

Thanks again

 

[Missile]

Excellent, works great.

Thanks

Try

=IF(A60<>"",
IF(ISNA(VLOOKUP(A60,data,20,0)),"",
IF(VLOOKUP(A60,data,20,0),VLOOKUP(A60,data,20,0),"")),"")

 

[ozgrid.com]

I wouldn't use the double VLOOKUP method with ISNA. See page below for
betters ways.
http://www.ozgrid.com/Excel/stop-na-vlookup.htm