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.

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.