Monthly Archives: March 2012

Bill Jelen: “From 1979 – VisiCalc and LOOKUP”!

You read correctly – 1979. In Bill’s last installment for VLOOKUP WEEK 2012, we go back to 1979…VisiCalc and the whole ’20 Functions’ available in that time! There were no IF statements and there was no VLOOKUP…but there was ‘LOOKUP’. Follow along and see where VLOOKUP began!

Mike Girvin “VLOOKUP WEEK Double Header Wrap Up!”

Mike ‘ExcelisFun’ Girvin has produced Tutorials each day this week for the VLOOKUP WEEK 2012 effort. In this post, Two (2) Videos Tutorials from Mike!

VLOOKUP WEEK 2012 Tutorial #5: “CHOOSE Function – Beginner to Advanced with 12 Examples

“Unlike other lookup functions, CHOOSE lets you lookup “things” besides values: Text, Numbers, Formulas, Functions, Cell References, Ranges, Defined Names, Array Constants” You may Download the workbook at:


VLOOKUP WEEK 2012 Tutorial #6: “Excel Lookup Picture Approximate or Exact match

    1. See how to use a formula with INDEX and MATCH functions and Defined names to do Approximate or Exact match lookup.
    2. See formula inserted into picture for Excel 2010 and 2003.
    3. See formula inserted into bitmap image for Excel 2007.

You may Download the workbook at:

Find more of Mike Girvin’s Excel Tutorials at ExcelisFun On YouTube.

From ‘The Data Specialist’: “A look at the VLOOKUP function”

From ‘The Data Specialist‘ on WordPress comes an Introduction to VLOOKUP with a comparison to INDEX/MATCH:

“Since Bill Jelen (MrExcel) launched a VLOOKUP week, I figured it was a good occasion to take a look at this function and also compare it with the INDEX/MATCH alternative. In order to prevent my post from being too long, I decided to dedicate this entry to the VLOOKUP function only.” … To Read More Click Here to go to The Data Specialist’s Lesson.

Crystal Long: “VLookup to Calculate Distances using Latitude & Longitude”

From Microsoft Access MVP Crystal Long

“My VLookup video calculates distance between coordinates using VLookup to get Latitude and Longitude from a table of Zip Codes, which is available as a free download on my website. There is also Concatenation, Errors (of course) and how to fix them, Relative and Absolute References, Range Names, Transposing, VBA, Table Styles, Formatting, and Conditional Formatting.”  … To Read More Click Here to go to Crystal Long’s Lesson.


Crystal Long may be found at Strive4Peace as well as on YouTube Learn Access by Crystal

Mike Girvin: “Approximate Match & Sort To Reduce Match Calc Time”

Mike “ExcelisFun” Girvin is really taking VLOOKUP to Task! In this 4th daily installment for VLOOKUP WEEK 2012, Mike Offers us “Approximate Match & Sorting To Reduce Exact Match Calculation Time”.

Download the sample workbook at:


Find more of Mike Girvin’s Excel Tutorials at ExcelisFun On YouTube.

From XL-Dennis: “Using VLOOKUP in VB”

From XL-Dennis we have an entry that uses a VLOOKUP in Visual Basic [VB]!

“I thought it would be interesting to create a case and see how VLOOKUP can be part of  VB-solutions. Actually, for several years ago I did similar solutions but with classic VB (VB6) for a customer. Imagine that we have a price list for our products. Because of the frequent price updates the company has decided to store it in a MS Excel workbook.” … To Read More Click Here to go to XL-Dennis’ Lesson.

Among other places around the Cyber-Globe, XL-Dennis may be found at The VSTO & .NET & Excel Blog

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

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