Formulas > =INDIRECT()

How to Use INDIRECT() in Google Sheets

Description

Returns a cell reference specified by a string.

How To Actually Use INDIRECT() in Sheets

INDIRECT(cell_reference_as_string, [is_A1_notation])

Try INDIRECT yourself

In cell D1, use the INDIRECT function to reference the value in cell B2 by providing the cell reference as a string. The correct answer must display the value from B2.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Anika Asks: How to Bring value from other cells | How to Reference an array in a cell

She has a cell, this D one, in which it says, for instance, another array or a row or column in this case, a column, a on sheet one where we're on and she's referencing that from another cell.

Intermediate

INDIRECT() SORT() TRANSPOSE()

Big Year Update Edit Your Weekend Highlights

Updated Big Year to make it easy to edit your weekend highlights. And I did something Google Sheets said was impossible! Really. Watch the video and see. Get Big Year: https://bettersheets.co/bigyear

INDIRECT()

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Tic Tac Toe In A Google Sheet

Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

AND() COUNTA() FILTER() IF() IFERROR() +4 more

Create a Sheet of Sheets for Project Management and/or Data Management

Create an epic organization sheet of all your spreadsheets. Unlock the secret to compiling all your scattered information into one easy-to-use sheet. Learn how to merge data from multiple tabs with this one-sheet solution. Perfect for creating summaries and dashboards. Get started now and streamline your workflow!

COUNT() INDIRECT() REPT() SPLIT() TRANSPOSE()

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.

COLUMN() IF() INDEX() INDIRECT() ROW()

Create a Waterfall of AI Prompts and Responses

This is an attempt to create a waterfall effect in sheets. Where an AI response becomes the prompt in another ai API call.
I show you one way not to do it, that fails with onEdit() but then I do show one particular way it could work. We wrestle with AI a bit in this video and the conclusion is not so sweet.

Get the sheet below with the Apps Script and API code already written for you.

Advanced

IF() INDIRECT() ISBLANK()

Transcript-matched member videos for INDIRECT(). Click through to watch.

Watch more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

How to Refer to Other Cells - A1 and R1C1 Explained

Get down to basics of spreadsheets.

Beginner

Unlock these tutorials

Learn more about the INDIRECT() formula:

Generate a INDIRECT() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses INDIRECT(). 2 free AI generations, no signup. Members get unlimited use.

Generate a INDIRECT() formula