Dec 13, 2018 Excel INDIRECT Function. Excel INDIRECT function returns the reference specified by a text string. Syntax of INDIRECT Function: INDIRECT(reftext, [a1) Here, reftext (required): This argument can take any of the following inputs: A cell reference of A1style.