To read the accompanying INDIRECT Function in Excel article, go here: ️https://www.simonsezit.com/article/how-to-use-the-indirect-function-in-excel/

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 cell-based 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/four-free-courses/

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/ssit-first-month-free

Check out our Excel 2021 tutorials for beginners playlist here
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Watch more popular tutorials from Simon Sez IT:

Microsoft Word 2019 playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jPMO6219NPPGA0WD2Pm0As

Microsoft Project 2019 course playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jo_PtA6h6LNhvMbWNtJsXL

Microsoft Excel 2019 Beginners playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gABy6lbJgp6kZtXVhadATg

Microsoft Excel 2019 Advanced playlist:
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9

GET FOUR FREE COURSES https://www.simonsezit.com/four-free-courses

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
StreamSkill.com: https://StreamSkill.com/
YouTube Channel: https://www.youtube.com/user/simonsezittraining
LinkedIn: https://www.linkedin.com/company/simon-sez-it/

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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