Hi all,
I've attached the workbook containing the problem I'd like to solve. The "Week1" and "Week2" tabs each contain a table of the same name that will be referenced. In the "% Change" Tab, I want to calculate the % Change from Week1 to Week2 for each value- e.g. in cell B2, I want to look up the corresponding value in Week1 and Week2, and calculate the percentage change.
The list of "Programs" in column A of "Week1" and "Week2" can change, as pictured in the example, so hopefully the formula could account for this.
Thanks so much for the help!
Bookmarks