Blank

M

Missile

Using the belowing formula in Sheet 1 Cell K80 (Date Formatted)
=IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE))

If Data,20 is blank how can I change the formula to have cell K80 also
blank, currently the result is zero, which is 00 Jan 00 under date formatting.

Thanks
 
M

Max

Basic construct eg .. IF(VLOOKUP=0,"",VLOOKUP)
Try
=IF(ISBLANK(A60),"",IF(VLOOKUP(A60,Data,20,FALSE)=0,"",VLOOKUP(A60,Data,20,FALSE)))
Success? hit the YES below
 
M

Missile

Thanks for your reply,
Your formula worked to an extent, but when I applied it to all of column K
it brought up some #N/A errors, the below formula worked a treat.

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

Thanks again
 
M

Max

Your formula worked to an extent ..
Not true. The suggestion addressed precisely what you posted here (reference
your original posting). When you are targeting a missile, you'd want it
pinpointed on the intended target, no? Carpet bombing serves no purpose other
than mass destruction.
 

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