MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU

[phill]

HI

=IF(ISNA(VLOOKUP(B38,AF1:AG121,2,FALSE)),0,VLOOKUP(B38,AF1:AG121,2,FALSE))

IS THERE ANYWAY THAT THE ZERO IN THIS EQUATION CAN BE CHANGED SO THAT IT
DISPLAYES A BLANK CELL INSTEAD?

MANY THANKS

[SVC]

Replace the 0 with two double quotes ("").

"phill" wrote:

> HI
>
> =IF(ISNA(VLOOKUP(B38,AF1:AG121,2,FALSE)),0,VLOOKUP(B38,AF1:AG121,2,FALSE))
>
> IS THERE ANYWAY THAT THE ZERO IN THIS EQUATION CAN BE CHANGED SO THAT IT
> DISPLAYES A BLANK CELL INSTEAD?
>
> MANY THANKS

[Elkar]

Yup, just change the 0 to a double-quotes ""

HTH,
Elkar


"phill" wrote:

> HI
>
> =IF(ISNA(VLOOKUP(B38,AF1:AG121,2,FALSE)),0,VLOOKUP(B38,AF1:AG121,2,FALSE))
>
> IS THERE ANYWAY THAT THE ZERO IN THIS EQUATION CAN BE CHANGED SO THAT IT
> DISPLAYES A BLANK CELL INSTEAD?
>
> MANY THANKS

[SteveG]

Phill,

Change the zero to "".

HTH

Steve