index match

Excel's MATCH formula is an extremely useful yet underutilized function within Excel's toolkit of formulas.  The reason people underestimate its value is because the MATCH formula's primary objective is fuzzy and ambiguous.  Without the proper context, its usefulness and potential applications are not obvious. The MATCH Continue Reading >>
Learning the VLOOKUP formula is, for most people, the first step taken towards becoming an advanced Excel user.  For me, this milestone actually occurred in 2004 during an internship at Microsoft in the company's Commercial Operations Division.  One of the senior analysts showed me the ropes by teaching me the formula.  While Continue Reading >>
OFFSET MATCH MATCH is the final lookup combination I'll cover among the lookup formula options you have available to you in Excel.  Of all the different lookup options you have to do a two-way lookup, INDEX MATCH MATCH is still probably your best bet and the approach I would generally recommend.  However, OFFSET MATCH MATCH ... Continue Reading >>
VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn.  While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it's still a good idea to learn this formula combination and Continue Reading >>
INDEX MATCH Not Working?  The following article provides the most likely causes of your problems with using INDEX MATCH. If you're an advanced user of Excel, you've likely already made the switch from VLOOKUP to INDEX MATCH because of the several advantages that INDEX MATCH provides.  Within Excel, INDEX MATCH is one of the most Continue Reading >>
If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>
When deciding between which vertical lookup formula to use, the majority of Excel experts agree that INDEX MATCH is a better formula than VLOOKUP.  However, many people still resort to using VLOOKUP because it’s a simpler formula.  One major driver of this problem is that most people still don’t fully understand the benefits Continue Reading >>

How to Learn Excel

by Matthew Kuo on January 16, 2013

in Excel

The majority of people who are really good at Microsoft Excel will tell you that they gained their knowledge simply through experience.  When I was a management consulting analyst, I’d frequently be given tasks that I thought were impossible with a spreadsheet; the process of coming up with an Excel solution was what really Continue Reading >>

How to Use VLOOKUP

by Matthew Kuo on December 19, 2012

in Database Theory, Excel

For most Excel users, VLOOKUP is the first complex formula they learn.  Performing a lookup is an extremely valuable function for any situation where you’re dealing with large data sets.  While the VLOOKUP function itself has become somewhat dated, as there are other better alternatives such as INDEX MATCH, it is still important Continue Reading >>
The Complete Guide to Excel Lookup Formulas One of the most common tasks in Excel is the process of looking up specific values within a data set.  In a simple database, this process would be completed by writing a “query” for a specified “table.”  For Excel, you complete this task by using a “formula,” with specific Continue Reading >>

Related pages

excel 2010 conditional formatting multiple conditionsrandom name chooser for teacherscheck mark in webdingshistograms binsexcel formula is blankiserror formula with vlookupexcel vba delete entire rowexcel find duplicate rowsexcel 2010 chart axis labelsmicrosoft office home and student 2007 trial downloadnormal distribution excel graphvlookup is not workinglogical formulas in excel 2007 with examplesfilter shortcut excelexcel referencingv look up in excelacademic probation uclashortcut keys in excel 2007 for filterexcel formulas hlookupucla anderson class profilecolumn graph excelcomplex excel spreadsheets examplesexcel null checktoo many different cell formats excel 2010 fixfrequency histogram excelhow to use lookup function in excel 2010count duplicate values in excelbin histogramucla anderson mba class profileexcel functions tutorial with examplesexcel vba if statementshow to make a line chart in excel 2010count if formula in excelinventory worksheet template excelarray formula in excel 2013binning in excelexcel shortcut paste special valuescalculate tax in excelexcel formula countifscool charts in excelvertical lookup excelduplicate excel sheet multiple timesvlookup rowsis there a way to delete duplicates in excelhistograms with excelhomework planner templateif statement in ms excelexcel bible pdftick on wingdingsdefinition of conditional formatting in excelexcel true or false formulausing the lookup function in excelucla academic probationdecision trees excelhow to remove rows in excelvlookup and hlookup in excelhow do you do a tick in exceldelete function in excelhow to perform a goal seek analysis in excel 2013brackets exceldelete duplicate rows excelwhat is vlookup and hlookupexcel random number generator no duplicatesawesome excel templateshow to use excel random number generatorpricing matrix excelrandom name picker classroomvba code vlookupcountif rangeif statements in excel 2007formulas for exceltranspose excel formulausing vlookup in excel 2010excel database lookupexcel compare two lists