Indirect

 

The INDIRECT function in Excel returns the reference specified by a text string.

1. For example, the INDIRECT function below reduces to =INDIRECT("C2"), =C2, 5

Cell

Do we really need the INDIRECT function for this? Yes. Below you can find the result without using the INDIRECT function.

Without Indirect Function

2. For example, the function below reduces to =SUM(INDIRECT("E3:E6")), =SUM(E3:E6), 27

Range

Note: the & operator is used to join strings. Border for illustration only.

3. For example, the function below reduces to =AVERAGE(Scores), 9

Name

Note: the named range Scores refers to the range C2:C4.