INDIRECT Formula Excel

This Excel Tutorial demonstrates how to use the Excel INDIRECT Function in Excel to create a cell reference from text, with formula examples.

INDIRECT Function Description:

The INDIRECT Function Creates a cell reference from a text string.

Formula Examples:

indirect function examples

Example Formula Result
R1C1 =INDIRECT(C5,D5) Creates a cell reference from text.
A1 =INDIRECT(C6,D6) Creates a cell reference from text.
$a$1 =INDIRECT(C7,D7) Creates a cell reference from text.
Range – Used in Sum =SUM(INDIRECT(C8,D8)) 21

Syntax and Arguments:

The Syntax for the INDIRECT Formula is:

Function Arguments ( Inputs ):

ref_text – A string representing a cell reference or range reference. The string can be in R1C1 or A1 format, or can be a named range.

a1 – OPTIONAL: Indicates whether the reference is in R1C1 or A1 format. FALSE for R1C1 or TRUE / Ommitted for A1.

Additional Notes

Use the INDIRECT Function to create a cell reference from text.

First create the string of text that represents a cell reference. The string must either be in the usual A1-Style column letter & row number (M37) or in R1C1-style (R37C13). You can type the refernce directly, but usually you will reference cells which define the rows and columns. Last, enter which cell reference format you choose. TRUE or Omitted for A1-Style reference or FALSE for R1C1-style.

While working with INDIRECT Formulas, you may want to use the ROW Function to get the row number of a reference or the COLUMN Function to get the column number (not letter) of a reference.

Return to the List of all Functions in Excel

How to use the INDIRECT Function in Excel:

To use the AND Excel Worksheet Function, type the following into a cell:
After entering it in the cell, notice how the AND formula inputs appear below the cell:
indirect formula syntax
You will need to enter these inputs into the function. The function inputs are covered in more detail in the next section. However, if you ever need more help with the function, after typing “=INDIRECT(” into a cell, without leaving the cell, use the shortcut CTRL + A (A for Arguments) to open the “Insert Function Dialog Box” for detailed instructions:
how to use the indirect function in excel

For more information about the INDIRECT Formula visit the
Microsoft Website.

Posted in