Look in the help index for VLOOKUP. Or, use a FIND macro.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"gmoore" wrote in message
...
I have two worksheets, one has the customer's name and address, customer
ID,
etc. The other contains the customer's ID and last date of purchase. How
can
I combine the two?