Course Content

Excel Formulas

## Excel Formulas

# INDIRECT

The **INDIRECT** function converts a text string into a cell reference. This can be particularly useful for creating dynamic references that change based on user input or other variables.

ref_text | A text string representing the reference to a cell or range of cells. |

[a1] | Optional. A logical value that specifies the `A1` or `R1C1` reference style. If omitted, `A1` is assumed. |

It is used to change the cell reference within a formula without altering the formula itself quite straitghtforward and simple but really helpfull in some situations.

Using this formula you may encounter an error `#REF`

. This is because If ref_text is not a valid cell reference.

The text string provided to the **INDIRECT** function is not correctly formatted to point to a valid cell or range because it is just text. That's why the `#REF!`

error arises.

Everything was clear?