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?