INDIRECT function in Excel

INDIRECT function in Excel

You can download the workbook here to follow along with the Video!

The INDIRECT() Function is one of those functions that can distinguish an Excel pro from an Amateur!

INDIRECT allows us to give it an address in the form of a string/text and then it goes to that address and it returns the value on that address. It also allows us to build dynamic references/addresses by concatenating different pieces of string together.

In this tutorial, I show you how to use the INDIRECT function and we show examples for passing addresses for a Table, A Cell, A Named Range, A Sheet, or a Workbook to the INDIRECT function and show you how you can create dynamic addresses.

So make sure to watch the video to understand the awesome INDIRECT function and join the elite Excel users!

I hope you like that Tutorial.

Please watch the video and let me know if you have any comments or feedback in the comments section below.

Please share

If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!

Ace your Excel Career by learning how to create Excel Dashboards!

Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others

2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.

3-Learning Dashboarding techniques.

4- Building a Complete Excel Dashboard.

Click here Find out more

Check course contents!