Posted to microsoft.public.excel.misc
|
|
Blank Cell
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
--
Regards
Dave Hawley
www.ozgrid.com
"Missile" wrote in message
...
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
"ozgrid.com" wrote:
=IF(OR(ISBLANK(A60),VLOOKUP(A60,Data,20,FALSE)=0), "",VLOOKUP(A60,Data,20,FALSE))
--
Regards
Dave Hawley
www.ozgrid.com
"Missile" wrote in message
...
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
|