Excel Function : INDIRECT
Category
Lookup and reference
Description
Returns a reference indicated by a text value
Microsoft Excel Reference Page
https://support.office.com/en-us/article/INDIRECT-function-474b3a3a-8a26-4f44-b491-92b6306fa261
Syntax and Description of the INDIRECT Excel Function
The INDIRECT function in Excel returns a reference to a cell or range of cells based on a text string. The basic syntax for the INDIRECT function is:=INDIRECT(ref_text, [a1]) Where: ref_text – is the reference to the cell or range of cells you want to return. This can be a cell reference, a named range, or a text string that refers to a cell or range of cells. [a1] – is an optional argument that specifies whether the cell reference is an A1-style reference or an R1C1-style reference. If omitted, the cell reference is assumed to be an A1-
About INDIRECT Excel Function
The INDIRECT function returns the reference specified by a text string. For example, =INDIRECT("A1") returns the value in cell A1. The INDIRECT function is useful for creating a cell reference based on a value in another cell. For example, you can use the INDIRECT function to create a cell reference based on a value in another cell, which can be used to create a dynamic named range.
