I know about VLOOKUP and INDEX and MATCH and OFFSET.
I need use the function in a "volatile" ARRAY.
How do I create the ARRAY with a client lookup criteria?

"Bernard Liengme" wrote:

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