Skip to content

indirect

Excel Function – INDIRECT()

  • ilyar126 

Description Indirect function extracts the value of the referenced cell. Syntax 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 Examples 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… Read More »Excel Function – INDIRECT()