| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX error
hi,
i have the following: =INDEX(alldata!$E$1:$E$44444,MATCH(C3,alldata!$C$1 :$C$44444,0),MATCH(pivot!$C$6,alldata!$A$1:A$44444 ,0)) but i am getting #REF error. the cells frmo the pivot sheet are actually coming from a pivot table, and the pivot!$C$6 is a date. im not sure what is causing the error. thanks in advance, geebee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX MATCH #N/A Error | Excel Worksheet Functions | |||
| VLOOKUP, INDEX & MATCH ERROR HELP | Excel Worksheet Functions | |||
| #num Error index, match | Excel Worksheet Functions | |||
| Index function error | Excel Worksheet Functions | |||
| INDEX and #REF error | Excel Discussion (Misc queries) | |||
Threaded Mode
