=INDEX({"AB","XY"},MATCH(B1,{10,11},0))


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