| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error suppressing with INDEX/MATCH
Hi, To prevent th nasty #NA in my sheet, I use
=IF(ERROR(MATCH( .... ));"";INDEX( .. ;MATCH( ...)) But now the aclculation time has increesed dramaticaly, Is there another way to do this Thanks a lot if anyone could help me with this -- There are only 10 types of people in the world: Those who understand binary and those who don't. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX/MATCH/LARGE returning #VALUE! error | Excel Worksheet Functions | |||
| Conditional Formulas--Suppressing error values? | Excel Discussion (Misc queries) | |||
| VLOOKUP, INDEX & MATCH ERROR HELP | Excel Worksheet Functions | |||
| #num Error index, match | Excel Worksheet Functions | |||
| Error Return Value from and INDEX(A:2,MATCH()) function | Excel Worksheet Functions | |||
Threaded Mode
