INDIRECTReturns a cell reference specified by a string.
Make a copy
Note: Each example is in its own tab.
Student Info data as a separate sheet in the spreadsheet.
Returns the contents of the reference which can be a cell or an area.
cell_reference_as_string – A cell reference, written as a string with surrounding quotation marks.
is_A1_notation – [OPTIONAL – TRUE by default] – Indicates if the cell reference is in A1 notation or R1C1 notation.