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 >>
When writing a series of VLOOKUP formulas, one of the annoying things is having to see the "#N/A" error after Excel has determined a lookup value is not available.  While we don't want to show any values when they are truly unavailable, from a visual design perspective, it's sometimes better just to show a blank space ... 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 >>
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 >>
While cold calling is practice that most students dread, from a teacher’s perspective, it’s an effective way to encourage students to prepare for and participate in class. We’ve all been on the wrong side of this situation at least once in our lives, coming to class completely unprepared.  And the natural thing to do when 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 >>
HLOOKUP is essentially the horizontal version of VLOOKUP.  The primary reason for using HLOOKUP in Excel is for when you have key data points arranged horizontally across the top of your table.  This usually happens when you are dealing with time series data; people have a tendency to list lookup values horizontally with this 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 >>
VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel.  This tutorial assumes you already have a decent understanding of how to use VLOOKUP.  If you do not, please click here for a beginner’s tutorial on VLOOKUP. Objective VLOOKUP MATCH is an improved variation of your basic VLOOKUP or INDEX MATCH Continue Reading >>

Related pages

stacked column chart with multiple seriesmacro formula excelmicrosoft excel query tutorialname randomizer for teachershow to get rid of lines in excelgauss curve excelvlookup na errorexcell modelsmatrix calculation exceloffset in vbapowerquery for excelhlookup in excel 2010 with examplems word tick symbolvlookup usesdeduplication in excelhow to insert a checkmarkremove duplicates excel 2010excel formulas and exampleshow to do v lookupvlookup to find multiple matchesexcel chart horizontal linehow to put error bars in excel 2007ucla salary scaleor in countifslookup vs vlookuphow to write a nested if statement in excelhow to place a tick in exceloperational bottleneckexcel cpk templateremove gridlines excelcountifs in excelbell curve in excelinserting check mark in excelfilter excel columnsusing vlookup in excel 2010lookups excelexcel 2003 iferrorcorrect mark symbolexcel planning calendar templategoal goldrattmatch excel formuladelete duplicate rows in excel 2010microsoft hup scamcompare rows in excelmyucalvlookup closest matchgenerating random numbers in excelchart layout excelexcel mean deviationthe goal sparknotesexcel formulas with examples in excel sheet vlookupexcel isna ifhow to delete duplicate numbers in excelexcel formula criteriaexcel formula to find duplicates in a listucla student insurancems word tick markdownload microsoft word 2010 free trialexcel 2010 identify duplicatesexcel unique numbersexcel vba randomizegraph templates exceledit array excelhow to construct a histogram in excelpivot table querysequential number generator excelquestions to ask in mba interviewexcel formula duplicatesbell graph excelformulas in excel sheet3d cluster chart excelsort formula excel