INDIRECT |
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) A logical value indicating whether to return A1 or R1C1 reference notation: True / 1 = A1 notation is returned (default) False / 0 = 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 * For the Google documentation refer to support.google.com |
|
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top