Excel Function – INDIRECT()

Description

Indirect function extracts the value of the referenced cell.

Syntax

INDIRECT(ref_text, [a1])

• ref_text: cell address such as A1 or R1C1 format
• [a1]: if blank then assumes TRUE(), using standard cell reference. If FALSE() then assumes R1C1 format

Examples

Below are few examples how to use INDIRECT. Note that cell references have to be written in double quotations “”

You can also use a combination of ADDRESS function to pass numerical row and column info instead of A1 format.

References

Check how to write ADDRESS() function.