INDIRECT Example to summarise divisions across sheets

Please purchase the course before starting the lesson.

INDIRECT Example to summarise divisions across sheets.

We need to (quickly) pull through the totals from the subsequent sheets but we don’t want to manually do the linking.

  • In D8 to G8 put in the exact sheet names
  • In D10 to G10 pull through the column you will want from the sheets (the TOTAL column on the other sheets).
  • In L18 to L34 pull through the row that you want to pull through to match the income statement item
  • In D18 to G34 use ADDRESS and INDIRECT functions to pull through the correct numbers from the correct sheets.

To see the full course contents click here.

Back to: Advanced Excel Course > Key Lookup Functions