Tag Archives: MATCH

From ‘Smitticisms’: “IF Statements and LOOKUPS”

 Smitty writes: “This article will focus on the appropriate use of IF statements, and also show you when it’s better to move into more robust formulas like LOOKUP, VLOOKUP, HLOOKUP & INDEX/MATCH.”  …To Continue on with Smitty’s Tutorial click here

.


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 decided to dedicate this entry to the VLOOKUP function only.” … To Read More Click Here to go to The Data Specialist’s Lesson.


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

 

Find more of Mike Girvin’s Excel Tutorials at ExcelisFun On YouTube.


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


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.


Neil Malek “Fun with VLOOKUP”

Neil has prepared a video for VLOOKUP WEEK 2012 entitled “Fun With VLOOKUP”!

“In this episode, Neil shows how the MATCH function and a little Data Validation can make the VLOOKUP function more user-friendly.”

 

You may find Neil Malek at TV.KnackTraining.Com


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 did not burst the bubble of anyone new to VLOOKUP. To read why Charley likes INDEX/MATCH better than VLOOKUP, check out his complete post.


Bruce Mcpherson – INDEX and MATCH on Large Data Sets

Here is a nice trick with index and match on very large data sets that minimises the number of cells that match has to look at.  This article explores how you can use MATCH() to leverage sorted data to cut calculation times down to a fraction of their natural calculation times. To Read More Click Here to go to Bruce’s Lesson


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

VLOOKUP will never differentiate ATLAS from aTlas. Tom's formula can.