From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,000 courses taught by industry experts.

INDIRECT

INDIRECT

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

INDIRECT

“

- The indirect function. On its own, it doesn't do a whole lot, but you will find some value in this if you have to do summaries or need truly dynamic solutions. In this data set, we have a whole lot of colors. Now, if I go to C6, all right, and I'm going to type equals F14 and enter, we get teal. Okay? Equals G four enter, raspberry. But now indirect equals indirect, open parentheses, and there is an F in C3. I'm going to put an ampersand and then grab that 14, close parentheses enter. Look at that. Indirect allowed me to take the pieces of a reference and put 'em together and treat 'em as if they were a single reference. Let's go to H11, brick red. Okay, over here we have a summary page that we would like. We've got the location of St. Orange in cell C3. We want the person who's in charge of classroom operations. We want to grab some calculations and data. Let's look at the data. Over here we have City Center…

Contents