March 29, 2012

Charles Williams: “Why 2 VLOOKUPS are better than 1 VLOOKUP”

By MrExcel East

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.

Charles may be found at Fast Excel on wordPress as well as DecisionModels.com

About MrExcel East

Facilitator | Image Virtuoso | Tweet-Jacker | Permuted Floridian | View all posts by MrExcel East
This entry was posted on Thursday, March 29th, 2012 at 19:28 and tagged with , , , , , , , , , , , and posted in Basic VLookup Information, Intermediate VLookup Information, VLookup Basics, Vlookup in Excel, VLOOKUP WEEK. You can follow any responses to this entry through the RSS 2.0 feed.

One response to “Charles Williams: “Why 2 VLOOKUPS are better than 1 VLOOKUP””

Leave a comment