### INDIRECT(ref_text [,a1])

Returns the text string of the contents of a given cell reference.

 ref_text The reference to a range of cells. a1 (Optional) Whether to return A1 or R1C1 reference notation:True = A1 notation is returned (default)False = R1C1 notation is returned

#### Remarks

 * For an illustrated example refer to the page under Advanced Formulas.* This function is Volatile and will change everytime a cell on the worksheet is calculated.* This function will update when the workbook is recalculated by pressing F9.* The "ref_text" can contain an A1-style reference, an R1C1-style reference, a named range, or a reference to a cell as a text string.* If "ref_text" is not a valid cell reference, then #REF! is returned.* If "ref_text" is a reference to a row (eg "3:3"), then the column containing the function is used.* If "ref_text" is a reference to multiple rows then (eg "2:3"), then the column containing the function is used and an array is returned.* If "a1" = True, then "ref_text" is interpreted as an A1 style reference.* If "a1" = False, then "ref_text" is interpreted as an R1C1 style reference.* If "a1" is left blank, then True is used.* This function should be used when you want to change the reference to a cell within a formula without changing the formula itself.* This function will always be single threaded.* This function can be used to always reference the same cells regardless of whether they are moved or copied.* You can use the ADDRESS function to return the cell reference given a row and column number.* You can use the COLUMNS function to return the number of columns in a cell range or reference.* You can use the ROWS function to return the number of rows in a cell range or reference.* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =INDIRECT("C1") = 60 100 2 =INDIRECT(B8,FALSE) = 200 200 3 =INDIRECT("B8",TRUE) = B2 300 4 =INDIRECT(T(B8)) = B2 400 5 =INDIRECT(named_range) = B10 500 6 =INDIRECT("B"&"5") = 500 E 7 =INDIRECT(B6&"6") = "some text" 60 8 =INDIRECT("'"&"B12"&'!"&B10) = 'Worksheet Name'!\$A\$2 B2 9 =INDIRECT("'["&B13&"]"&B12&'!"&B10) = '[Workbook Name.xls]Worksheet Name'!\$A\$2 "some text" 10 =INDIRECT("2:2",TRUE) = 200 \$A\$2 11 =INDIRECT("2:2",FALSE) = #REF! RC1 12 =SUM(INDIRECT("B" & "1" & ":" & "B" & "5")) = 1500 Worksheet Name 13 =ROWS(INDIRECT("1:10")) = 10 Workbook Name.xls 14 =INDIRECT(ADDRESS(5,5)) = RC1 15 =INDIRECT(#REF!) = #REF!