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.