Blank Cell

M

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
 
O

ozgrid.com

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

Jacob Skaria

Try

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

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
 
M

Missile

Excellent, works great.

Thanks


Jacob Skaria said:
Try

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top