Good day - I am trying to pull data from three sheets in the same workbook to generate a report, My issue is that the software that generates the data creates columns in this way:
Products Code Date Results
Product1 Oct 21/2010 234
Product2 Oct 21/2010 342
I used the lookp function but it will return the lower value at all times, how can I make the look up function look for the date AND the product grade so I can pull the appropriate results to the report, or is there another way of doing this?
Thank you again for your helpful thoughts, I had attached a xls file for a demo
Regards,
Yasir