# 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