#### javajoe

##### Board Regular

- Joined
- Nov 7, 2005

- Messages
- 78

I have a fairly large spreadsheet which uses INDEX/MATCH to perform a variety of lookups on each row. Unfortunately, when I added an IF/ISERROR to the front of each equation to see if a result is found in the lookup (see below), it significantly and very noticeably slows down the entire workbook, and sometimes even hangs at NOT RESPONDING. This is on a computer with a fast processor and 1 gig of memory.

My question is this... is there any other way to make this formula faster, while achieving similar results? The only thing I have figured out is to eliminate the IF/ISERROR function (thus cutting the lookups in half), but I really need that functionality if possible.

Here is my formula:

=IF(ISERROR((INDEX(refZIPZONE!$A$2:$H$10000,MATCH($J2,refZIPZONE!$A$2:$A$10000,0),7))),"OUT OF AREA",(INDEX(refZIPZONE!$A$2:$H$10000,MATCH($J2,refZIPZONE!$A$2:$A$10000,0),7)))

I found a few other posts on the topic but didn't find anything with a better alternative. Any help would be greatly appreciated!

Thanks!!

DAN