The INDIRECT function is very useful in case you have
derived or calculated in a cell the cell reference from where you want the data
from.
For Example, if cell A3 has a value C5 (May Be calculated
based on some formula or logic) and you want to refer C5 from A3 to get the
value of cell C5:
=Indirect(A3)
