INDEX(reference, row_num [,column_num] [,area_num]) |
Array Form - INDEX(array, row_num, column_num) |
Returns the value from a cell range which is the intersection of a row AND a column. |
| reference | The reference to one or more cell ranges. |
| array | (Array Form Only) The array of values to use. |
| row_num | The row in array from which to return a value. |
| column_num | (Optional) The column in array from which to return a value. |
| area_num | (Optional) The area to use when there is more than one. |
Remarks |
| * For an illustrated example refer to the page under Lookup Functions * This function will return the value in the cell (or array) at the intersection of the "row_num" and "column_num". * The array form can be used in conjunction with an array constant but is not used very often. * This function can return a single value or multiple values. * This function can return multiple values when entered as an Array Formula using (Ctrl + Shift + Enter). * If "reference" contains non adjacent cells, then an "area_num" must be provided. * If "reference" contains non adjacent cells, the cell ranges must be enclosed in parentheses. * If "row_num" is left blank, then "column_num" is required. * If "row_num" is too small or too large, then #REF! is returned. * If "column_num" is left blank, then "row_num" is required. * If "column_num" is too small or too large, then #REF! is returned. * If "area_num" is left blank, then 1 is used. * If "area_num" is too small or too large, then #REF! is returned. * You can use the CHOOSE function to return the value in a row (or column) based on an index number. * You can use the XLOOKUP function to return a value in the same row (or column). * You can use the XMATCH function to return the position of a value. * You can use the MATCH function to return the position of a value. * You can use the VLOOKUP function to return a value in the same row. * You can use the HLOOKUP function to return a value in the same column. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top