Hello, I am trying to do a vlookup across two different tables.
In this table, I have an actuals spend (2021A) field. I want to look at the 2nd table and sum the total spend with the matching category and fiscal year. In this spreadsheet I will end up with a matching column for all future fiscal years (out through 2030) and will repeat this sumif out through those columns. The sumif should could any fiscal year that matches "2021" OR "All" from the second table.
Any help would be greatly appreciated!
In this table, I have an actuals spend (2021A) field. I want to look at the 2nd table and sum the total spend with the matching category and fiscal year. In this spreadsheet I will end up with a matching column for all future fiscal years (out through 2030) and will repeat this sumif out through those columns. The sumif should could any fiscal year that matches "2021" OR "All" from the second table.
Synergies Spend Tracker.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Spend Category | 2021P | 2021A | ||
2 | IT synergy (Workday & Salesforce) | $0.9 | |||
3 | Other synergy (RealEstate) | $0.5 | |||
Sheet1 |
Synergies Spend Tracker.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Spend Category | Description | Fiscal Year | Savings Total | ||
2 | IT synergy (Workday & Salesforce) | Savings 1 | 2021 | $0.90 | ||
3 | Other synergy (RealEstate) | Savings 2 | All | 0.02 | ||
4 | IT synergy (Workday & Salesforce) | Savings 3 | 2022 | 0.2 | ||
Actuals Tracking |
Any help would be greatly appreciated!