Look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bosser" wrote in message
...

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.




--
Bosser