• Home
  • /
  • Blog
  • /
  • Indirect Function in Excel

Indirect Function in Excel

Learn about Indirect function in Excel and about how to use Indirect function with Vlookup. 

Use this function to create a reference that won't change even if a row or a column is inserted in the worksheet. 

Understanding Indirect Function

In this video you will find:
1. What is indirect function?
2. Example of using indirect function
3. Creating named ranges to work with indirect function
4. Converting a cell to a librarian and using it as an indirect formula to complete multiple sum functions

Combining Indirect & Vlookup Functions 

Follow this step by step Advanced Excel tutorial to learn how to use the Vlookup function with Indirect function. Find data in arrays easily using this combination.

In this video you will find:
1. How to create data validation lists
2. How to create Named Ranges
3. The issue with just using Vlookup function
4. Adding Indirect function to get the data required to be looked up

Hope you found these tutorials useful. If you did, please leave your comments below.

share this

Get 25 Creative PowerPoint Ideas Mini Course &
 Members-only tips & offers. Sign up for free below: