The Excel INDIRECT Function Use Cases - Create a Dependent List and Reference Named Range
Use INDIRECT Function to create a dependent list and reference and named range. The INDIRECT Function returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.