Indirect function extracts the value of the referenced cell.


INDIRECT(ref_text, [a1])

  • ref_text: cell address such as A1 or R1C1 format
  • [a1]: if blank then assumes TRUE(), using standard cell reference. If FALSE() then assumes R1C1 format


Below are few examples how to use INDIRECT. Note that cell references have to be written in double quotations “”

You can also use a combination of ADDRESS function to pass numerical row and column info instead of A1 format.


Check how to write ADDRESS() function.

Leave a Reply

Your email address will not be published. Required fields are marked *