VLookup in Excel

Crystal Long Declares: “Not Over Yet… Convert VLOOKUP Equations to MS Access!”

               

DLookup, DMin, Align controls…? What is this!?

“We’re Going To Need A Bigger Week!”

               

Just when you thought it was safe…

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

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

Learn Excel from MrExcel