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

T

TeeGee

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
 
J

JE McGimpsey

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.
 
T

TeeGee

Thank you for your help. I'll try it!

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

TeeGee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank Page After Envelope-Label Wizard 5
Vlook-up in report with column Expansion 5
Publisher is filling blank lines with data 2
Excel 2002: Return blank when VLOOKUP on blank cells 2
Return BLANK is cell value sought is blank 13
v look up formula to generate a blank line 1
How can i use lookup for data in reverse column ? 8
Get rid of Microsoft AutoUpdate 0

Top