INDEX

Mike ‘ExcelisFun’ Girvin: “INDEX and MATCH How-To”

               

Mike ‘ExcelisFun’ Girivn checks in for day 3 of VLOOKUP WEEK 2012 with “INDEX and MATCH How To”. There are approximately 30 examples in this 1 hour ‘+’ video! Example Files are available – Download files: https://people.highline.edu/mgirvin/ExcelIsFun.htm [youtube=http://www.youtube.com/watch?v=u-8D2G0y9EM]

Tom Urtis: Lookup with 2 or more criteria

               

Today’s post from Tom Urtis involves finding the record that matches two criteria, such as Chevrolet in column A and 4-Door in column B. The solution involves INDEX, MATCH entered as an array formula, so this is ranked pretty high on the Excel spicy scale. Read the complete article here.

Charley Kyd from ExcelUser.com never uses VLOOKUP

               

When I announced VLOOKUP Week, Charley Kyd was one of the first to respond with something along the lines of “I never use VLOOKUP and I will be happy to tell you why!”  Although Charley was one of the first to respond, I figured I should hold this post for a few days so I(…)

Bruce Mcpherson – INDEX and MATCH on Large Data Sets

               

Large Data Set to run a Lookup on? No Problem!

Tom Urtis: Case-Sensitive VLOOKUP

               

VLOOKUP doesn’t care about upper or lower case. If you have ABC and Abc, VLOOKUP will see that as a match. In today’s article for VLOOKUP Week, Excel MVP Tom Urtis shows how to do a case-sensitive lookup. This is a great trick! Read Entire Article

Learn Excel from MrExcel