INDIRECT()

Description

Returns a cell reference specified by a string.

How To Use in Sheets

INDIRECT(cell_reference_as_string, [is_A1_notation])

External Links

INDIRECT & OFFSET

Google Docs Help

3Better Sheets Tutorials

Creating A Dark Mode Theme | Announcing Dark Habits
IntermediateMost Popular
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Anika Asks: How to Bring value from other cells | How to Reference an array in a cell
Intermediate
How Can I Compare Two Tabs for Differences?