Microsoft Exel MVP Charles Williams sends in his contribution to VLOOKUP WEEK.
For all you VLOOKUP junkies who can’t get enough of VLOOKUP, here is a wonderful reason to use 2 VLOOKUPs instead of 1 !!
Exact Match VLOOKUP is slow
When you have a lot of data in Excel (think 10,000 or 100,000 or 1,000,000 rows) you often need to detect when a value you are looking for does not exist in the data.
You can do this using VLOOKUP and the formula…” To continue reading Charles’ lesson click here.