Lookup Formula problem**************please help

[banditpurple]

this formula in c2
#N/A

started with b2
JF
KN
MW
TW
DG
KS
RP
SM
VM
Misc
BB
BRB
CJ
DN
SG

WHAT I AM TRYING TO ACCOMPLISH with this formula.
Below is my key - 2 letters and I need to assign a different letter.
JF,MW,KN,TW,="A"
RB,CJ,SG,DN,BB,="S"
RP,DG,VM,KS,SM,="G"

This formula above gives me n/a on TW, DG, SM, VM, BB, BRB, CJ, DN, SG. ? Please help.

[daddylonglegs]

LOOKUP requires the lookup range to be sorted ascending - better to use HLOOKUP or VLOOKUP, e.g. this formula if you don't want a separate table

=HLOOKUP(B2,{"JF","MW","KN","TW","BRB","CJ","SG","DN","BB","RP","DG","VM","KS","SM";"A","A","A","A","S","S","S","S","S","G","G","G","G","G"},2,0)

or just list all your possible codes in one column and values to return in the next, name that whole thing Table and use

=VLOOKUP(B2,Table,2,0)

[banditpurple]

wow daddylonglegs. Thank you SO much. YOU ROCK!