Gary,

Thank you very much, So simple yet works a treat.. One for my notebook!!

Cheers
Carl

"Gary''s Student" wrote:

Don't use VBA, use VLOOKUP()


In Sheet1, B1 enter:
=VLOOKUP(A1,Sheet2!A$1:B$3000,2) and copy down

--
Gary''s Student - gsnu200772