If you're brand new to VLOOKUP or haven't used the formula in a while, the following quick reference guide is a great resource to have handy.  It's created by the folks at Microsoft, so you know it's legitimate. Reference Guide Summary The quick reference guide is in PDF format and is three pages long.  It goes into ... Continue Reading >>
The vast majority of Excel users have never used VLOOKUP's range lookup feature.  Most Excel users familiar with the VLOOKUP formula are just conditioned to know that, when they get to the range lookup option portion of the VLOOKUP syntax, they should just put in the word "FALSE" because they want an exact match.  This ... Continue Reading >>
Writing a Nested IF Statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced.  The first time I used this technique was during my new employee training, right before I became a business analyst in management consulting.  The overall concept of writing a Nested IF is ... 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 >>
The IFERROR formula was designed to solve a common aesthetic problem that most of us have encountered when using Excel - when we know that there are errors in our data, but we'd prefer not to see Excel's standard error message notation.  Error messages usually consist of all caps lettering that is preceded with the "#" ... 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 >>
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 >>

Related pages

goldratt the goal moviemicrosoft access 2010 free trialexcel 2003 vlookupexcel lookup not workingexcel how to identify duplicatesgoal by eliyahu goldrattmanpower histogram excel templatevba excel cell valueexcel vlookup syntaxucla discountslottery random number generator excelhow to plot normal distribution in excel 2010round to the nearest thousand in excelgraph charts in excelusing multiple if statements in excelmy housing uclaformula of vlookup in excel with exampleucla theme park ticketsexcel remove duplicate entriesexcel count duplicatepassword generator excelwhat is hlookup in excel with exampleamazing excel chartshow to draw normal distribution curve in excel 2007vlookup exelvlookup with multiple resultsiserror excelwingdings 2 downloadexcel formulas multiple cellswhat is countif function in excelcheckmark for excelcountif in excel examplehow to do countif in excelexel bookexcel cheat sheet formulascheckmark or check markvlookup between two sheetsremove duplicates in a listhow vlookup works in excel 2010open excel without macrosucla weyburn parkingvba offset valuehighlight duplicates excel 2010sample pay stub excelexcel stack columnswhere to find a tick symbol in wordexcel compare 2 lists for duplicatesucla course schedulethe goal goldrattbell curve generatorappend formula in excelhlookup dan vlookuphow do you make a stacked bar chart in excelcreate vlookup excel 2010excel consolidate duplicatesucla gshipwriting a macro in excelhow to create bar graph on excelexcel normal distribution probabilitymyucla loginexcel cell drag not workingfind duplicate entries in excelexcel modeling tutorialhow to write formulas in excelformulas for excel 2007build histogramwriting a macro for excelhow to create bar and line chart in excel 2010ms excel 2007 formulas listhorizontal vlookupinsert tick mark in excelcalendar layout in excelhow to use vlookup to compare two columnscalendar chart excelexcel numericexcel 2007 vlookupvlookup with multiple criteria and multiple sheets