INDIRECT Function
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.
Formula:
=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.
