Cell Value

[chad32]

Hi. In Column A I have a number of differnet country codes and for 2 of them I want to change the value in Column B. For Example if cell A1 is = to "SHA" I want cell B2 to be "SHANGHAI". If cell A1= to "SGN" I want B1 to be = to "HO CHI MINH". If cell A1 is = to anything else I want the value to B2 to remain unchanged.

 

[Oaktree]

Try something like =CHOOSE(1+(A1="SHA")+2*(A1="SGN"),B1,"Shanghi","Ho Chi Minh")

 

[chad32]

I could'nt get it to work. Is there anything else i could try?

 

[Dave Patton]

try
=IF(OR(A2={"SGN","SHA"}),LOOKUP(A2,$K$2:$L$3),A2)

or equivalent

=IF(OR(A4={"SGN","SHA"}),LOOKUP(A4,{"SGN","HO CHI MINH";"SHA","SHANGHAI"}),A4)

Revise ranges as necessary