Worked like a charm! Thnaks for the reminder that everything doesn't have to
be as complicated as I make it.

"Gary''s Student" wrote:

=VLOOKUP(A1,Sheet1!A1:B100,2,FALSE)

of course the 100 can be changed to match your needs.

--
Gary''s Student - gsnu200800