Define categories

[puffyboy]

Good day. I need to define the grade of employees for insurances plan. Column A is the grade code and column B is the grade name.

I need in column C, where grade code 1 & 2 = Plan A, grade code 3 = Plan B, and rest 4 to 9 = is Plan C {Where grade code 10 to 12 = empty}

Thank you in advance,

Regards,

[benishiryo]

welcome to the forum. maybe:
="Plan "&LOOKUP(A2,{1,3,4},{"A","B","C"})

[ramananhrm]

Please try this function

From the cell C2
=VLOOKUP(A2,{1,"Plan A";3,"Plan B";4,"Plan C";10,""},2)

[puffyboy]

Thank you very much for your help.

[Pete_UK]

Put this formula in C2:

=INDEX({"Plan A","Plan B","Plan C",""},MATCH(A2-1,{0,2,3,9}))

then copy down to the bottom of your data.

Hope this helps.

Pete