Formulas > =INDIRECT()
How To Use INDIRECT() Function in Google Sheets
Description
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.
Hints (2)
-
Remember to use quotation marks around the cell reference.
-
The INDIRECT function requires the reference to be in string format.
7 Better Sheets Tutorials
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()
Creating A Dark Mode Theme | Announcing Dark Habits
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
ARRAYFORMULA()
CONCATENATE()
COUNTIF()
FILTER()
IFNA()
+6 more
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.
INDIRECT()
SORT()
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.
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.
IF()
INDIRECT()
ISBLANK()
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()
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