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

lynda uclahow to use countifsvlookup and matchexcel bar chart stackedwriting an if statement in excelhow to delete duplicates in excel 2010indirect excel function examplenum error in excelhow to convert xl to pdfexcel replace formulavlookup compare columnswhat is a nested if statementworking in excel with formulastornado chart excelcourses on excel spreadsheetsdeleting duplicate rows from a tableadvanced excel formulas tutorialexcel formula syntaxiferror in vlookupscenario modelling in excelexcel cell color if statementhow to learn vbaexcel formulas timesexcel matching formulams excel advanced tutorialdefinition of rows in excelhow to use two if statements in exceldefine formula in excelcalendar layout in excelexample excel macrohlookup function excelmba consultant reviewsexcel macro to delete duplicate rowscustom formats in excelexcel graph generatorif statement in excel formulavlookup not workingvlookup across workbookshow to dedupe in excelexcel 2010 vlookup examplevlookup function in excel 2013hbs case study methodwww recreation ucla edutick in box symbolexample of countifvlookup formula in excel 2007tutorial on excel formulasexcel file convert to pdfthe most used websiteremove duplicates excel vbahow does vlookup work in exceliferror function in excel 2010insert numbers in exceltask tracker excel templatehow to insert a total row in excelvlookup na errorconsulting names generatormeaning of vlookup and hlookupthe goal movie goldrattif na vlookupcount duplicates in excelif and vlookup functionexcel template buildernormal curve in excelusing transpose in excelshortcut keys in excel 2007 for filterhow to use the lookup function in excelmyyclahow to create bell curve in excel 2007duplicate rows excelexcel delete duplicates