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.


 =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

Usage Examples

Leave a Reply

WORKDAY Function

The WORKDAY function in Excel takes a date and returns the nearest working day. This is achieved based on user

Read More »

MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells,

Read More »
Scroll to Top