vlookup

E

emartin

How can I get rid of the 0 (zero) and show only a blank
when using the vlookup function.
 
F

Frank Kabel

Hi
what is your exact formula?
One way would be
=IF(VLOOKUP(...)=0,"",VLOOKUP(...))
 
E

emartin

the exact formula i am using is

=INDEX($A$6:$F$15, MATCH("Lupita Herrera",$A$6:$A$15,),
MATCH("Avg",$A$6:$F$6,))

Thanks so much for your help.
 
F

Frank Kabel

Hi
try:
=IF(INDEX($A$6:$F$15, MATCH("Lupita Herrera",$A$6:$A$15,),
MATCH("Avg",$A$6:$F$6,))=0,"",INDEX($A$6:$F$15, MATCH("Lupita
Herrera",$A$6:$A$15,),
MATCH("Avg",$A$6:$F$6,)))
 

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

Help With VLOOKUP 2
Use & with two formulas 2
VLOOKUP & Data Validation 0
HELP!!!!!!!!! 2
Can I add a formula or function to Vlookup? 1
vlookup formatting problem 1
Avoiding redundant calculations 7
Same forumula returns both 0 & N/A 2

Top