How can I get rid of the 0 (zero) and show only a blank when using the vlookup function.
E emartin Aug 30, 2004 #1 How can I get rid of the 0 (zero) and show only a blank when using the vlookup function.
F Frank Kabel Aug 30, 2004 #2 Hi what is your exact formula? One way would be =IF(VLOOKUP(...)=0,"",VLOOKUP(...))
E emartin Aug 30, 2004 #3 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.
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 Aug 30, 2004 #4 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,)))
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,)))
