Excel INDIRECT function

Function              INDIRECT

Description        Excel INDIRECT function takes input of reference to cell and returns the value of reference.

Syntax  INDIRECT(ref_text, [a1])

array  A range of cells, or reference to cell.

ref_text  A reference to be put as text.

a1  [optional] A TRUE, FALSE to indicate A1 or R1C1-style reference. Default is TRUE = A1 style.

Example: