The INDIRECT() is a Lookup and Reference function, which takes the arguments "ref_text, a1" and it returns the source indicated by the text characters or series.


=INDIRECT (ref_text, a1)
In the above syntax, the argument "ref_text" acts as a source to a cell which possesses A1 style and R1C1 style reference
"A1" denotes the nature of reference existing in ref_text cell.

Video Tutorial:

Let us view how the INDIRECT function can able to provide the source from the text series with the help of below video.

Learn MS Excel

Ask Questions

Ask Question