Microsoft® Excel® 2010 Formulas & Functions Inside Out

INDIRECT()

Syntax. INDIRECT(reference,A1)

Definition. This function converts a text string into a reference.

Arguments

• reference (required). Expects an expression that can be interpreted as a string. The function converts this string into a valid reference (a cell reference or named range).

• A1 (optional). Must be evaluated as a logical value. Defines whether the reference argument is in A1 syntax (if the argument returns TRUE or is omitted) or the R1C1 syntax (if the argument returns FALSE).

Background. If the reference argument cannot be evaluated to a valid reference or name, the function returns the #REF! error.

If you want to use an external reference to another workbook, the workbook must be open.

Example. The following examples show how this function ...