Hello
Not sure how else to describe this one.
I have a summary tab with project names already in.
I have those projects in their own separate tabs.
The summary tab has a Actuals column, Forecast column and a Delta column.
In each project tab, is has a total row for each of the above column headings ie: Actuals, Forecast and Delta BY MONTH. So I have 3 times 12 totals (January has columns for actuals, forecast and delta)
What I would like to do is in the summary tab, for each project get the figure from the project tabs for each actuals and forecast, depending on the month I choose in the summary tab.
ie: In the summary tab I choose, January, I want to show for all projects, what the Actual total is, as well as forecast and Delta.
Currently I have the following:
=IF(ISNA(VLOOKUP($B$1,INDIRECT("'" &$C7 &"'!$a$1:$BZ$10000"),K$1,FALSE)),0,VLOOKUP($B$1,INDIRECT("'" & $C7 & "'!$a$1:$BZ$10000"),K$1,FALSE))
Where B1 is the lookup row value in each project tab (TOTALS)
C7 is the Project name in the Summary sheet
k1 relates to column numbers, I have number all columns in the summary and project tabs.
Any thoughts?
Thank you in advance
Bookmarks