Is there anyway to amend this so it tells you it's not found what it's
looking for rather then copying the last posted dated?



"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