Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index with 2 arrays returns error
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index with 2 arrays returns error
Thanks. The solution is only putting a paranthesis around the array.
"PapaDos" wrote in message ... =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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index with 2 arrays returns error
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula using array to find embedded value | Excel Discussion (Misc queries) | |||
IF - returns name error | Excel Worksheet Functions | |||
AVERAGE function returns #DIV/0! error | Excel Discussion (Misc queries) | |||
GetpivotData returns a #REF! error | Excel Worksheet Functions | |||
Index function error | Excel Worksheet Functions |