VLOOK (HOW DO I GET RID OF A BLANK 0 ???)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

WHEN USING VLOOK, HOW DO I GET RID OF A 0 AFTER IT FINDS BLANK DATA IN THE
REQUESTED COLUMN INDEX #? I WOULD PREFER IT JUST LEAVES A BLANK.

THANK YOU FOR YOUR HELP,
TEE GEE
 
Please turn your caps lock off - it's harder to read than mixed case,
and it's generally considered the equivalent of shouting.

one way:

=IF(VLOOKUP(...)="","",VLOOKUP())

another:

Format the cell with

Format/Cells/Number/Custom General;General;;@

Note that using this option, the cell will still contain 0, but it won't
be displayed.

Also note that you can't use the latter option if 0 is a legitimate
value in your lookup table.
 
Thank you for your help. I'll try it!

(Sorry about the CAPLOCKS.) I am usually a stickler about the same thing.

TeeGee
 
Back
Top