R
Rasoul Khoshravan
I am trying to understand Index function
Index(array, row-num,column-num,array-num)
I have to arrays as a1:e4 and f1:I4
30 45 60 75 10 11 12
Apple 4 3 2 1 Ali 12 13 14
Orange 5 2 3 4 Hassan 15 16 17
Banana 2 4 3 1 Zahra 18 19 20
Following function, returns error (apparently on 2 as array number and I
expecting it to return 19
INDEX(A1:E4,F1:J4,4,3,2)
what is wrong with this command?
Microsoft assistant site says Index has two forms, array and reference,
however it doesn't explain the reference type.
Index(array, row-num,column-num,array-num)
I have to arrays as a1:e4 and f1:I4
30 45 60 75 10 11 12
Apple 4 3 2 1 Ali 12 13 14
Orange 5 2 3 4 Hassan 15 16 17
Banana 2 4 3 1 Zahra 18 19 20
Following function, returns error (apparently on 2 as array number and I
expecting it to return 19
INDEX(A1:E4,F1:J4,4,3,2)
what is wrong with this command?
Microsoft assistant site says Index has two forms, array and reference,
however it doesn't explain the reference type.