✅To read the accompanying INDIRECT Function in Excel article, go here: ➡https://www.simonsezit.com/article/ho...

The INDIRECT function is part of the Lookup and Reference group of functions in Excel. It is unique in many ways because it is an Excel function that does not perform any calculations, evaluate conditions, or perform logical tests. So, what does INDIRECT do, and why is it useful?

Excel INDIRECT is used to indirectly reference cells, ranges, other sheets, or workbooks. It lets you return the reference to a cellbased on its string representation. As a result, you can change a cell reference within a formula without changing the formula itself. Here’s how to use the INDIRECT function in Excel.

GET FOUR FREE COURSES https://www.simonsezit.com/fourfree...

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssitfirst...

Check out our Excel 2021 tutorials for beginners playlist here
✅   • Excel 2021/365 Training Tutorials for...  

Check out our FREE 300+ hour training course playlist here ➡
   • Simon Sez IT Long Training Courses  

Watch more popular tutorials from Simon Sez IT:

✅Microsoft Word 2019 playlist    • Word 2019 Training Tutorials for MS W...  

✅Microsoft Project 2019 course playlist    • Microsoft Project 2019 Training Tutor...  

✅Microsoft Excel 2019 Beginners playlist:
   • Microsoft Excel 2019 Training Tutoria...  

✅Microsoft Excel 2019 Advanced playlist:
   • Advanced Excel 2019 Training Tutorials  

GET FOUR FREE COURSES https://www.simonsezit.com/fourfree...

Stay in touch!
✅SimonSezIT.com: https://www.SimonSezIT.com/
✅StreamSkill.com: https://StreamSkill.com/
✅YouTube Channel:    / simonsezittraining  
✅LinkedIn:   / simonsezit  

Subscribe to our channel:
https://www.youtube.com/simonsezittra...

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel ;)