Vlookup Week

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(…)

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,(…)

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: http://people.highline.edu/mgirvin/ExcelIsFun.htm [youtube=http://www.youtube.com/watch?v=wojchNbrCqA]   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(…)

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(…)

Learn Excel from MrExcel