From the course: Excel 2016: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Returning references with the INDIRECT function
From the course: Excel 2016: Advanced Formulas and Functions
Returning references with the INDIRECT function
- [Voiceover] The Excel function called Indirect is very unusual. And if you encounter it by way of the formulas tab, suppose you're looking at Look Up and Reference functions, the description doesn't quite tell us how we might use this. Returns the reference specified by a text string. In this worksheet called Indirect, it's actually tabulating data from four different sheets. The primary purpose of this worksheet is to gather data by way of a function like this, a sum function, a 3D type function. It's adding up data from four separate sheets. Now what's not being done here though is a total being calculated or shown from each of the sheets. If we want a total for the East sheet here, I can type equal. I'll click on the East sheet down below and go to cell G6 and click it and press enter. And I could certainly do the others in short order. But what if this list is much larger? Maybe it covers 10 regions, 20 regions. Maybe it's all states. Maybe it's multi-country. We'd like to be…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.