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},TABLE1 [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,CHOOSE({1,2},TABLE1[0],TABLE1[PROJECT]),2,0),"")=0,"",PROPER(VLOOKUP(C9,CHOOSE({1,2},TABLE1[0],TABLE1[PROJECT]),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,CHOOSE({1,2},TABLE1 [0],TABLE1[PROJECT]),2,0),""))=0,"",PROPER(VLOOKUP(C9,CHOOSE({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 , ""