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

.

Advertisements

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.