Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index and Match Function Help
Hi all,
I have a peculiar problem with a function. I am using Excel 2007. I am working with about 57,000 records. I must match the rate of an audio call based on two conditions. I am using the following formula against a list that is sorted in ascending order: =INDEX('Rate Table'!$E$34:$H$98,MATCH('Veri vs Interc Clean Data 2010 '!G597,Entity,0),MATCH('Veri vs Interc Clean Data 2010 '!E597,'Rate Table'!$E$33:$H$33,0)) I can find a match for all but 600 or so records. There is a match, without a doubt for the other 600. I have made sure that the text the lookup is based on is clean...no trailing or leading spaces. I have even cleared the cells and retyped the data just as it is in the lookup table. No matter how many times, I write it or how I modify the function, those records return 0. I have also updated Excel, ran diagnostics, copied the data to a new workbook, opened and repaired...I just do not know what else to try. Of course, the report is due Friday morning. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX w. MATCH function | Excel Worksheet Functions | |||
Help with Index / Match function | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
index match function help me | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |