Skip to content

XL Lookup & Reference

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()

Excel Function – ADDRESS()

  • ilyar126 

Description To calculate the address of a cell in an worksheet. You can use this function to refer cells in other worksheets as well. Syntax ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text]) row_num: specifies the row number col_num: specifies the column number [abs_num]: optional, which row or column to be fixed (absolute) with $ or relative [a1]: optional, it specifies A1 or R1C1 reference style if set to False or left blank.… Read More »Excel Function – ADDRESS()