INDIRECT

Returns a cell reference specified by a string.

Examples

Make a copy

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.

Tip: You can't use table references in =INDIRECT yet. Try IMPORTRANGE instead.