Hi, I am creating a template with a summary sheet I'd like to run as follows but having some issues; Team populates the department example tabs with room scheduling info. This creates totals I want to pull into the summary sheet automatically. Trouble is rows/room types are added/removed out of my control and it errors as can no longer find that row.
In the summary tab, team should populate deptnames matching the tabs. The dept names are not known until the project is started. So, column C should reference column B (same row), find the appropriate deptexample sheet, find the 'Net functional area' reference (highlighted in dept tabs), and return the figure next to it. I've tried various combos of vlookup, Match, indirect, and index but can't seem to crack it - any assistance greatly appreciated thank you.
In the summary tab, team should populate deptnames matching the tabs. The dept names are not known until the project is started. So, column C should reference column B (same row), find the appropriate deptexample sheet, find the 'Net functional area' reference (highlighted in dept tabs), and return the figure next to it. I've tried various combos of vlookup, Match, indirect, and index but can't seem to crack it - any assistance greatly appreciated thank you.