Greetings Excel Guru's,
Hoping to find an answer here, I have a spreadsheet with a large number of tabs that need to all reference/look up information on another tab.
Attached data sheet - The first tab (Products 1) includes product IDs (Vertical) and dates (Horizontal). The second tab (Products 2) is similar to the first and the third tab (Totals) has dates every other column (Horizontal) and Product names (Vertically) - this final tab is the one all other tabs need to pull information from. I need the Products 1 and Products 2 sheet to look up the product ID and the date on the Totals sheet to find the count for each product on each date. I realize the easy solution would be to put the product names into the far left column and just have the dates consolidate (no space between) but there is a reason for this mess as the data is copied and pasted into the totals tab daily and products drop off and come back on the list at any given date. It would seem index and matching would be the solution, but I was not able to get it to work.
As an example of what I want on the first tab would be for B2 I want it to look at the Totals tab and find Product ID vertically and the date horizontally and give me the value in that field. The correct result would be 43.
Just a few notes: 1. I cant do Vlookup because the values I want on the first tab are on every other column on the second tab. 2. copy/paste the data is a solution, but the attachment is just sample data, the workbook I am using is much bigger.
Hope this all makes sense.
-Ryan
Bookmarks