Learn how to use the INDIRECT function to return the reference specified by a text string. See syntax, arguments, examples, and limitations of this function in Excel for Microsoft 365, Mac, and web.
https://support.microsoft.com/en-au/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261