Hello,
I could really use some help trying to figure out the right formula to use in the following scenario:
I have two tables. One is the main table on a separate tab that contains all of the formulas. I have another table on a separate tab that is part of a printable dashboard. The headers for both table are dates. What I would like to do is put a formula in the dashboard table that references the main table. I would like it to check the header of the dashboard table, find that matching header in the main table, and return the value of a specific row under that matching column header.
For example: Both tables are structured as such, with dates extending from D1 and on. My problem is, I can't fit all of these dates on the dashboard so next week, I'll replace 4/3/16 with 4/10/16 and so on. (In the dashboard tableWhat I need cell B2 to do is look for the date in B1 over in the main table's row 1, then, when it finds a match, return the value of the main table's row 2.
A B C 1 Week Ending 4/3/16 4/10/16 2 Doc Control Received (Planned) 3 Doc Control Received (Actual)
Bookmarks