<your solution has the source in column A and the looked-up
value in column B, regardless of whether they are a number or a
letter.

That is not correct

--
Kind regards,

Niek Otten


"Vindaloo" wrote in message
...

Thanks Niek, that works fine.

However I don't mean to sound ungrateful but that wasn't quite what I'm
after. The letters must always be in column A, and the numbers in
column B - your solution has the source in column A and the looked-up
value in column B, regardless of whether they are a number or a
letter.

Your use of INDEX / MATCH solves the problem of not having the key
value in the first column of the range (as required by VLOOKUP) -
thanks!

Thanks,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=531866