INDIRECT Function in Excel - Powerful Range References

The INDIRECT Function in Excel is one of the building blocks for powerful and dynamic formulas and functions and, in this tutorial, I show you exactly how it works, starting from basic examples and moving up to a more useful implementation of INDIRECT that allows you to create dynamic formulas. INDIRECT() Microsoft Docs: https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261 Excel File: https://www.teachexcel.com/excel-tutorial/2216/indirect-function-in-excel-powerful-range-references?nav=yt Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt This tutorial will also give you the skills you need to understand and build more complex formulas using this function. I hope you find the tutorial useful! :) TeachExcel.com