I am trying to return a value for a code of mixed characters from a list of a possible 250 codes. I want to identify potentialy 30 of those codes and return a value dependant upon that code. For example

Code Value
BT 3
KA27 2
KA28 2
PH 2
E1-6 5
SE1-8 5
BA 1 or blank
TA 1 or blank

I have tried using "IF" but can only use a max of 7 arguments,

I don't want to have to list every code in a table to apply the VLOOKUP. Is there a simply solution?

Your help would be much appreciated.

Many thanks.