Help with retrieving data

Hi,

I have attached an example spreadsheet on what I am trying to retrieve. On the left hand side I have data collected and on the far right side tells me what date the item was purchased. I just want to make the results automated (column M) by formula if possible by the user entering whatever data in Column L.

Your help would be greatly appreciated.

Example v2.xlsxHi, thanks so much for the quick reply. The formula worked great though if I were to use the same item numbers throughout the period it doesn't seem to work as well (see new attached example). Could you possibly adjust formula in case this were to occur?

Thanks again

Thanks so much for all your help, works great

Try this:

=INDEX(A$3:G$3,MAX(INDEX((A$4:G$11=L4)*(B$4:H$11=M$3)*COLUMN(A$4:G$11),)))

Normally Enter

Hi,
Try it without array formula...........
thanks




I have attached an example spreadsheet on what I am trying to retrieve. On the left hand side I have data collected and on the far right side tells me what date the item was purchased. I just want to make the results automated (column M) by formula if possible by the user entering whatever data in Column L.

Your help would be greatly appreciated.[/QUOTE]