You can also use VLOOKUP and use any order as long as you put FALSE or 0
as the 4th argument in the formula

=VLOOKUP(A2,{"1c",15;"1b",15;"1a",15;"2c",15;"2b", 15;"2a",15},2,0)


as an example


--
Regards,

Peo Sjoblom



"Martin Ledgard" wrote in message
...
Yep - solved it now. Cheers.