VLOOKUP

  • Thread starter Thread starter lehigh
  • Start date Start date
L

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
 
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
 
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.
 
Back
Top