| 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. |
| 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 | |||
Threaded Mode
