Indirect

Syntax

Indirect(Value[, A1])

Value. Link to the cell containing the link in the A1 or R1C1 style or name of the named cell range; or the link to the cell as a text string.

A1. The logical value that defines style of the link contained in the first parameter.

It returns the link specified as a text string.

Formula	Result	Description
=Indirect(A1)	5	Number in the B1 cell. The A1 cell contains the B1 text value.
=Indirect(C5)	10	Number in the Name named range. The C5 cell contains the Name text value.
=Indirect(concatenate("B",A2))	65	Number in the B5 cell. The A2 cell contains the 5 value.