Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

Excel INDIRECT formulaWhen 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

Free download INDIRECT workbook example

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.

Free Ebook

Leave A Comment

Share This