| | | If "array" contains only one row or column, the corresponding "row_num" or "column_num" argument is optional. |
| | | If "array" has more than one row and more than one column, and only "row_num" or "column_num" is used, then an array of the entire row or column in array is returned. |
| | | The "array" form always returns a value or an array of values; the reference form always returns a reference. |
| | | If "row_num" is left blank, then "column_num" is required. |
| | | If "row_num" and "column_num" do not refer to a cell within "array" then #REF! is returned. |
| | | If "column_num" is left blank, then "row_num" is required. |
| | | If "area_num" is left blank, then |
| | | If you are entering a nonadjacent selection for reference, you must put "reference" in parentheses. |
| | | If each area in "reference" contains only one row or column then the "row_num" or "column_num" argument, respectively, is optional. For a single row reference, you can use INDEX(reference,,column_num). |
| | | The first area selected or entered is numbered 1, the second is 2, and so on. If "area_num" is omitted, then 1 is used. |
| | | If both the "row_num" and "column_num" arguments are used, then the value in the cell at the intersection of "row_num" and "column_num". |
| | | If you set "row_num" or "column_num" to 0 (zero), the array of values for the entire column or row, respectively is returned. |
| | | To use values returned as an array, enter the function as an array formula in a horizontal range of cells. To enter an array formula, press (Ctrl + Shift + Enter). |
| | | This function can return a linked cell from a hard coded link range ?? |
| | | | A | B | C | | 1 | =INDEX({1,2;3,4},2,2) = 4 | Apples | 40 | | 2 | =INDEX({1,2;3,4},0,2) = 2 | Lemons | 20 | | 3 | =INDEX(B1:B2,1,1) = Apples | Bananas | 30 | | 4 | =INDEX(B1:B2,2,1) = Lemons | Peaches | 60 | | 5 | =INDEX((B1:B2,C3:C4),1,1,1) = Apples | | | | 6 | =INDEX(B1:C4,MATCH("Bananas",B1:B4,1),2) = 40 | | | | 7 | =INDEX(B1:C1,,2) = 40 | | | | 8 | =INDEX(B1:B4,,1) = #VALUE! | | | | 9 | =INDEX(B1:B4,,2) = #REF! | | |
| |
