0Index Function has two forms:
1. Array form - returns a value
2. Reference form - returns a cell reference
Array Form:
Syntax: INDEX(ARRAY, row_num, col_num)
Example: INDEX({10, 20, 30; 40, 50, 60}, 1, 2)
or INDEX((a1:c1,a2:c2), 1, 2)
The result for the below example is 20. Since we have got row 1 and column 2 we get 20
A B C
10 20 30
40 50 60
The 20 in column 2 is the answer
Reference form:
Syntax: INDEX(reference,row no, col no, area num)
example: INDEX((C4:E5,K5:M7),3,1,2)
C D E
| 5 | 4 | 3 |
| 3 | 2 | 1 |
K L M
| 2 | 3 | 4 |
| 6 | 2 | 5 |
| 3 | 6 | 7 |
answer for above one is 3
In the above equation we have choosen 2 array, K5 to M7 in which the row no is 3 and col no is 1
Please let me know for any doubts
