Blank Cell
 

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

Blank Cell
 

=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

Blank Cell
 

Try

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

--
Jacob


"Missile" wrote:

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

Blank Cell
 

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

Blank Cell
 

Excellent, works great.

Thanks


"Jacob Skaria" wrote:

Try

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

--
Jacob


"Missile" wrote:

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

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