Better Sheets

Formulas > =INDIRECT()

How To Use INDIRECT() Function in Google Sheets

Description

<div>Returns a cell reference specified by a string.<br><br><strong>Common questions about the INDIRECT formula: </strong><br>1. What is the syntax of the INDIRECT formula?&nbsp; INDIRECT(cell_reference_as_string, [is_A1_notation])<br>2. How do I reference a different worksheet with the INDIRECT formula? Write the worksheet in quotes in the formula.<br>3. What are some tips for troubleshooting the INDIRECT formula? Check if the data you entered is correct.<br><br><strong>How can the INDIRECT formula be used appropriately? </strong><br>The INDIRECT formula can be used to reference data located in another tab or sheet or cell. This could be done by creating a reference to a text string or cell. You'll use basic text within quotes to reference a cell, tab, or sheet.<br><br><strong>How can the INDIRECT formula be commonly mistyped? </strong><br>The INDIRECT formula can be easily mistyped as IDIRECT, or DIRECT, or INDIRCT, or INDERECT, or INDRECT, or DIRECTIN, or DIRCTIN, or DIRCT, or UNDIRECT, or UNDIRCT.<br><br><strong>What are some common ways the INDIRECT formula is used inappropriately? </strong><br>One common way that the INDIRECT formula is used inappropriately is by creating a reference to the wrong cell, or range, or sheet. If you programmatically edit the cell reference within the INDIRECT formula you can easily mess it up by just referencing the wrong cell reference.<br><br><strong>What are some common pitfalls when using the INDIRECT formula? </strong><br>One common pitfall when using the INDIRECT formula is that the syntax can sometimes be hard to remember. Additionally, the formula can be quite slow to calculate when large ranges of data need to be referenced. If you use INDIRECT as a substitute for <a href="https://bettersheets.co/formulas/arrayformula">ARRAYFORMULA</a>, this could slow down your sheet.<br><br><strong>What are common mistakes when using the INDIRECT Formula? </strong><br>Common mistakes when using the INDIRECT Formula include misspelling the formula name, not providing quotations around the worksheet name, and forgetting to include a cell address in the formula.<br><br>One common way that the INDIRECT formula can be mistyped is by entering parentheses around the worksheet name, which will generate an error. Additionally, forgetting to enter quotation marks around the worksheet name will also generate an error.<br><br><strong>What are common misconceptions people might have with the INDIRECT Formula? </strong><br>Some common misconceptions people may have with the INDIRECT Formula is that the formula can reference a range when it cannot and that it is necessary to include a worksheet name in the formula when it is not.<br><br><br><strong>Google Sheet Formula Frustrations Solved</strong></div><div>Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.<br><br></div><div>Have you heard of the mysterious and powerful <a href="https://bettersheets.co/formulas/if">IF</a> formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner <a href="https://bettersheets.co/formulas/isblank">ISBLANK</a>().&nbsp;</div><div><br>At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level.&nbsp;</div><div>From <a href="https://bettersheets.co/formulas/arrayformula">ARRAYFORMULA</a>() to <a href="https://bettersheets.co/formulas/ztest">ZTEST</a>(), Better Sheets has it all.&nbsp;</div><div><br></div><div>There’s no shortcuts to becoming a Google Sheets pro! Learn more here at Better Sheets</div><div><br></div><div>Watch the magic for yourself. Video tutorials at every turn here at Better Sheets.</div><div><br></div><div>Your spreadsheets will never be the same again.</div><div><br></div>

How To Actually Use INDIRECT() in Sheets

<pre>INDIRECT(cell_reference_as_string, [is_A1_notation])</pre>
Google Docs Help

7 Better Sheets Tutorials

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() ISBLANK() INDIRECT()

Creating A Dark Mode Theme | Announcing Dark Habits

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Most Popular Intermediate
TODAY() COUNTIF() CONCATENATE() IFNA() ARRAYFORMULA() +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.
Intermediate
INDIRECT() TRANSPOSE() SORT()

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.
INDEX() IF() ROW() COLUMN() INDIRECT()

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!
TRANSPOSE() SPLIT() REPT() COUNT() INDIRECT()

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.
IF() AND() INDIRECT() FILTER() NOT() +4 more

Big Year Update Edit Your Weekend Highlights

INDIRECT()

Learn more about the INDIRECT() formula:

INDIRECT & OFFSET

Generate a INDIRECT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons