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

[Guest]

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

 

[Guest]

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

 

[Guest]

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

HTH,
Elkar

 

[SteveG]

Phill,

Change the zero to "".

HTH

Steve