route217
asked on
edit formula to not show 0 in cell
Hi experts using excel 2010
I am using the following formula in a cell and keep on getting 0 in the cell and I just want show blank...what's wrong..
Formula.Array
{=PROPER(VLOOKUP(C9,CHOOSE ({1,2},TAB LE1 [0],TABLE1[PROJECT]),2,0), ""))}
I am using the following formula in a cell and keep on getting 0 in the cell and I just want show blank...what's wrong..
Formula.Array
{=PROPER(VLOOKUP(C9,CHOOSE
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
like this
=if(PROPER(VLOOKUP(C9,CHOO SE({1,2},T ABLE1[0],T ABLE1[PROJ ECT]),2,0) ,"")=0,"", PROPER(VLO OKUP(C9,CH OOSE({1,2} ,TABLE1[0] ,TABLE1[PR OJECT]),2, 0),""))
=if(PROPER(VLOOKUP(C9,CHOO
ASKER
Thanks for the excellent feedback...and prof Jim jam...that edit formula not working..
did you enter with control shift enter?
can you try this
=if((PROPER(VLOOKUP(C9,CHO OSE({1,2}, TABLE1 [0],TABLE1[PROJECT]),2,0), ""))=0,"", PROPER(VLO OKUP(C9,CH OOSE({1,2} ,TABLE1 [0],TABLE1[PROJECT]),2,0), "")))
can you try this
=if((PROPER(VLOOKUP(C9,CHO
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So if error cannot help here
So you could add at the beginning IF. Then entire formula inside the parentheses = 0 then , ""