View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel @ Logicim Daniel @ Logicim is offline
external usenet poster
 
Posts: 1
Default How to use INDEX in an ARRAY that changes depending on a criteria

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