Use the Indirect Function to Create Excel Dashboards

The Indirect Function in Excel refers to a Text String in a cell. This is a handy tool to use - in conjunction with drop-down list created with Data Validation - for adding interactivity to an Excel Dashboard Report.

I use two different examples of the Indirect Function in this lesson. For the 2nd example I show you how to quickly lookup the value in any cell using the SPACE BAR as the "union" operator.


Danny Rocks
The Company Rocks

[MRaedAlLulu]

I really like you videos, and the way you demonstrate. Thank you so much, sir.

[jsmith]

Danny Rocks....For me, you have a very effective teaching style....and I wish you would post more videos!!! Wishing you health!

[DannyRocksExcels]

Thank you. I am pleased that you enjoyed my video.

Danny Rocks
The Company Rocks

[shunjayshun]

Hello Danny... Good one... have really amazed using the space bar between the two indirect function .... :) thank you ....

[DannyRocksExcels]

My pleasure! I am happy that I could help you with my video tutorial.

Danny Rocks
The Company Rocks

[srizki]

Danny, Thank you very much, it is excellent. I thought I know a lot in excel, but this simple "space" trick I did not know.
Thanks again.
Sohail Rizki

[DannyRocksExcels]

Yes, "Space" is the "Union Operator. Of course, this works best when you have named ranges for the rows and the columns in your data set.

In this case, it is faster and less complicated than the Index / Match combination.

Danny Rocks
The Company Rocks

[DannyRocksExcels]

@Exlslearn
Thank you! I am pleased that you enjoyed this video so much.

Let me try to help you:
1) As you saw in the video, I was using the INDIRECT() Function to refer to a "Text Strign" - but not just ANY "Text String."
2) This "Special" Text String was the Name for a "Named Range" of values.
3) In Excel, All "Named Ranges" MUST begin with a Letter and they CANNOT contain any SPACES.
4) So there, you are facing the main challenge - Named Ranges CANNOT containg any Spaces.

Danny

[mew]

I didnt know about the spacebar trick.. I would have used Index/Match to pull in the values for the intersection.

[javikjavik]

Very clear and helpful tutorial, cheers mate

[DannyRocksExcels]

@RAVISHTEJSINGH
Thank you. I am pleased that you enjoyed my video tutorial.

Danny Rocks
The Company Rocks

[kfong]

Hi all, this is another great tutorial.

[jamesPerry]

Excellent piece of Excel.
Thank u, Sir.

[DannyRocksExcels]

@djehoti
Thank you for your enthusiastic response! Very much appreciated!

Danny Rocks
The Company Rocks

[sirajmohammedali]

Great! Thanks for sharing, this will help me a lot in my work.

[amusaazeez]

Can you explain on how building three years financial statements
Because you are fantastic

[justjustinme]

Hello. My employer told me to learn how to create / use Excel Dashboards... but I don't know what they are, or how and where to start! Never even heard of Dashboards before. Any idea on where I should go to learn about them and how to create them?

I use Excel, but use basic functions such as sum, multiply, add, and a few basic if functions. I also use the PMT function (I am in accounting class).

[DannyRocksExcels]

@kfong6932
Thank you. I am so pleased that you enjoyed my tutorial.

Thank you for sharing your comment.

Danny Rocks
The Company Rocks

[rocky]

Thank you very for your videos.I taught many things by watching your videos. You are doing a great job.I am very thankful to you. Sir, I have a problem. I this video, when i entered formula [ =sum(indirect(value) ] I got an error #REF. I do not know why i am getting this error. I would be grateful to you if you help me. Thank You

[alexrosen]

Hi Danny and thank you for the videos. But I wonder where the workbooks are?