VLOOKUP

[lehigh]

Hi All

How can I modify the following formula to show a blank instead of a
zero if nothing exists in the field in the lookup table.

=VLOOKUP($B$2,COMPANIES!$F$8:$AX$4920,10,0)


Thanks for your help


Tom Snyder

 

[JulieD]

Hi Tom

=IF(VLOOKUP($B$2,COMPANIES!$F$8:$AX$4920,10,0)=0,"",VLOOKUP($B$2,COMPANIES!$
F$8:$AX$4920,10,0))

Cheers
JulieD

 

[Guest]

Probably not the way you are suppose to but I have also
just added a blank space in the table to do the same
thing.