Excel INDIRECT function
Function INDIRECT
Description Excel INDIRECT function takes input of reference to cell and returns the value of reference.
Syntax INDIRECT(ref_text, [a1])
array A range of cells, or reference to cell.
ref_text A reference to be put as text.
a1 [optional] A TRUE, FALSE to indicate A1 or R1C1-style reference. Default is TRUE = A1 style.
Example: