The Excel INDIRECT function returns the reference specified by a text string allowing you to change the reference within a formula without modifying the formula itself. This function allows you to create a reference from text.

Syntax:

 =INDIRECT (ref_text, [a1]) 
  • ref_text – A cell that contains an A1-style reference. Can also be a R1C1-style reference, named range, or a reference text string.
  • a1 – [optional] Does the reference use A1 or R1C1.
    • Default is TRUE = A1 style.
    • FALSE — ref_text must be “R1C1” style

* An #REF! error is returned if ref_text is not a valid cell reference.

Usage Example

INDIRECT Function
Usage Examples

Leave a Reply

XLOOKUP Function in Excel

XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!

Read More »

MONTH Function

The MONTH function in Excel returns the month component of a specified date as a number between 1-12. Syntax: =MONTH(serial_number)

Read More »
Scroll to Top