Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs
When to use Excel’s INDIRECT Function?
Excel’s INDIRECT function is useful when you need dynamic range references. For example:
You need to lookup values in different Excel sheets
You need to lookup values in different ranges depending on a global point of view selection
You need to create drop-downs that are dependent on another drop-down
This video gives you a quick understanding of the power of the INDIRECT function. Reading about it in the office support page can be a bit confusing (at least that was the case for me when I first read about it) – this video attempts to clear up that confusion.
Download the INDIRECT Workbook HERE
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports. Redeem your coupon for 75% off below.