=INDEX((A1:E4,F1:J4),4,3,2)

--
Regards,
Luc.

"Festina Lente"


"Rasoul Khoshravan" wrote:

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.