I've got a workbook with 700,000 cells. It uses VLOOKUP in about 110,000 of these cells. This causes the workbook to slow down so much that it almost hangs.
So I want to replace VLOOKUP with INDEX and MATCH, on the theory that this will use less CPU/Memory.
I've tried to create a replacement formula using these functions but it is giving me an #N/A.
I've attached a (small) sample workbook which contains my non-working formula, as well as the original VLOOKUP formulas which do work correctly so that you can see what I'm trying to accomplish.
Any advice? Thanks!
Bookmarks