Tom Urtis: “Reverse Intersecting Lookup: Return Row and Header Labels”


While tidying up the storeroom for the VLOOKUP WEEK Blog… we came across a few things – this is one. “I recently posted this example, followed by this more advanced example for finding an intersecting value in a table with multiple rows and columns. Today it’s the opposite scenario, where you identify a value in(…)

“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