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