INDIRECT

Returns a cell reference specified by a string. Learn more

Video field
Lookup

The INDIRECT function in Google Sheets is a formula that allows you to use a cell reference as a string in a formula. It takes a cell reference as a string and returns the value of the cell, allowing you to create dynamic references within your formulas.

The first argument, cellreferenceas_string, is a string that contains the cell reference you want to use. This can be either in A1 or R1C1 notation, depending on the value of the optional second argument.

The second argument, [isA1notation], is an optional Boolean value that specifies the notation of the cell reference in the first argument. If this argument is set to TRUE or is omitted, the cell reference is interpreted as A1 notation. If set to FALSE, the cell reference is interpreted as R1C1 notation.

Using the INDIRECT function can be helpful when you need to create a reference to a cell that changes dynamically, based on the value of another cell or some other condition.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!