Returns a cell reference specified by a string.
Examples
Note: Each example is in its own tab.
Sample usage
INDIRECT('Sheet2!'&B10)
INDIRECT('A2')
INDIRECT('R2C3', FALSE)
Student info
Student info data as a separate sheet in the spreadsheet.
Student marks
Returns the contents of the reference which can be a cell or an area.
Syntax
INDIRECT(cell_reference_as_string, [is_A1_notation])
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.