INDIRECT Function yields a reference to a range. The range being referred can be a named range, a range of cells or can be a cell. The formula is represented as
= INDIRECT (ref_text, [a1])
Several excel users have been mystified with the usage of INDIRECT function. If you are of the opinion that this function does not have a lot to offer to the users, then think again! There are several ways in which this function can be used in a workbook.
Referenced range is a cell
The content of the referenced cell is returned when the referenced range is a cell. For instance, if in cell G9 you enter D10 in A1 style and in a different cell you enter INDIRECT (G9), then this returns the value of the cell D10. From the following example, 32 is the number which is returned indirectly.
Reference is a range of cells
The INDIRECT function returns the contents of the cells referenced, when the referenced range considered is a range of cells. The syntax is represented as