PDA

View Full Version : Solved: Vlookup + ISBLANK?



lacviet2005
04-27-2007, 08:41 AM
Hi everyone,
I have a vlookup column and a few cells have "0", and i'd like to hide those 0(s).
Is there a way to combine Vlookup with ISBLANK?

=IF(ISBLANK(C1<>0),"",VLOOKUP(A1,table,3,False))
That's what i could think of, but not working!!! :doh:

Thanks for your help.
D

Bob Phillips
04-27-2007, 08:46 AM
=IF(VLOOKUP(A1,table,3,False)=0,"",VLOOKUP(A1,table,3,False))

lacviet2005
04-27-2007, 09:06 AM
AWESOME!!!
Thanks XDL.