| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index and match
I am having trouble getting the desired results using Index Match
The formula is as follows. =INDEX([RMSDaily.xls]Department!$C$4:$D$87,MATCH([RMSDaily.xls]Department!$C$2,[RMSDaily.xls]Department!$C$2:$D$2,0),MATCH("Grand Total",[RMSDaily.xls]Department!$A$2:$A$87,0),1) If I select the "Match" and test the function I am getting the row number and coulmn number. However if I select with Index for the Data range, I am getting "#Ref" as the result. The data is a Pivot Table and it has 217columns and 88 rows.Will that pose problem using Index and Match? Please help me. Thanks. Krish |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index, Match and filters | Excel Discussion (Misc queries) | |||
| Match Index | Excel Worksheet Functions | |||
| Match or Index Question | Excel Worksheet Functions | |||
| Match & Index | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
