This seems like a simple vlookup but it's not. I need a way to take information from a separate workbook where it needs to find the intersection of the column and row.
So I need to lookup from the current workbook cell A3=1-21-2003 and cell C3=Tray2 so the result will return "1" from the separate workbook.
Here is an example of the pivot table that I need to lookup to find the intersection
A B C D
Date: Tray1 Tray2 Tray3
1-21-2003 1 1 1
1-22-2003 2 1 2
1-23-2003 3 2 3
HELP me please!