Try,


=IF(B1<"",CHOOSE(B1,,,,,,,,,,"AB","XY"),"")


Mike

"Sanjiv" wrote:

I have :

A B
1 10
2
3 11
4 11
5 10

I want to write a formula in Col A that
If B=10 then in col A1= have a value say "AB"
if B=11 then in col A1= have a value say "xy"
else
Col A1=blank

Kindly help and many thanks for that.