Hi. I'm hoping you guys can help me get this answer. I'm sure its fairly simple for you guys. I am trying to gather info on a customer who ordered something last. I have all the data dumped on a "Data" tab and there may be multiple rows of the same item number and the same customer name. It looks like this:
Data Tab:
On different "Lookup" tab in the workbook, I want my lookup cells. In G6 on my lookup tab, I want to return the customer of the latest purchase date for that item by searching the item in column A and the latest date in column C.
I want to return the average sale price for each item (Column A) by looking at the data tab column I (Formula entered on the "Lookup" Tab in cell D6)
I also want to return the total sales for each item (Column A) by looking at column I (Formula entered on the "Lookup" tab in cell E6)
My Lookup Tab looks like this:
I really don't want to spend a ton of time doing filter sorts and manually entering thousands of rows, which is why I'm coming to you guys. Thanks in advance, I appreciate the help.
Data Tab:
On different "Lookup" tab in the workbook, I want my lookup cells. In G6 on my lookup tab, I want to return the customer of the latest purchase date for that item by searching the item in column A and the latest date in column C.
I want to return the average sale price for each item (Column A) by looking at the data tab column I (Formula entered on the "Lookup" Tab in cell D6)
I also want to return the total sales for each item (Column A) by looking at column I (Formula entered on the "Lookup" tab in cell E6)
My Lookup Tab looks like this:
I really don't want to spend a ton of time doing filter sorts and manually entering thousands of rows, which is why I'm coming to you guys. Thanks in advance, I appreciate the help.