Return a value for a known code

  • Thread starter Thread starter Bosser
  • Start date Start date
B

Bosser

I am trying to return a value for a code of mixed characters from a lis
of a possible 250 codes. I want to identify potentialy 30 of those code
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 th
VLOOKUP. Is there a simply solution?

Your help would be much appreciated.

Many thanks
 
Back
Top