Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
INDIRECT | Lookup and Reference
Excel Formulas
course content

Course Content

Excel Formulas

Excel Formulas

1. Basic Formulas
2. Array Formulas
3. Lookup and Reference

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_textA 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.

How can the INDIRECT function be useful in Excel?

Select the correct answer

Everything was clear?

Section 3. Chapter 3
We're sorry to hear that something went wrong. What happened?
some-alt