Go to Help and learn about VLOOKUP then come back if you nee more help
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Daniel @ Logicim" <Daniel @ wrote in
message ...
Column A = Client names
Column B = Items sold
Column c = Date sold

I want to get the Item Date of Purchase for a client who is indicated on
another worksheet.
There can be many Items per client and many clients for same Items