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

v look excelremove duplicates in excel 2010trend chart excelwhat is a stacked bar chartexcel identify duplicates in two columnshow to make bar graphs in excelucla student discountpaste special values shortcuthistogram chart excelexcel formula error messagesdelete duplicate cells excelbell curve on excelhow to use iserrorfuzzy logic excelron debruinchess lookuphow do i sort multiple columns in excelshortcut to excelsumif and matchexcel if statement return blankdelete a row in excel shortcutoffset vba excelhow to dedup in excelexcel inventory tracking templatefind unique values in excel 2010excel matching columnshow to create a stacked column chartexcel sort formula resultsdraw a normal distribution curve in excelexcel vba delete multiple rowsif statement in ms excelucla anderson academic calendarusing countifs in excelcompare two columns in excel 2010 for differencescreate macro excelhow to find duplicates in excel and delete themwhat does num mean in excelmy vlookup is not workingvlookup trainingexcel highlightertask log template excellogon.ucla.eduexcel formula previous cell plus 1excel remove headerhotkeys for excelcompare two columns in excel for matchesrandom lottery number generator excellabeling charts in excelvlookup in excel for dummiesexcel shortcuts and formulas pdfnested if functions excelcreating bar charts in excelfind duplicate records in excelall formulas of excel 2007 with exampleexcel sheet formulasexcel template builderexcel duplicate sheetvlookup functions in excelms excel functions with examplesexcel random password generator formulaexcel formula tutorialsrandom lotto number generator excelexcel graph makinglynda uclahow to build a macro in excelw-4 allowances calculatorzs associates salarieshow to erase duplicates in excelexcel stacked line graphexcel insert row with formulahomework schedule makerchess lookuphow we use vlookup in excelhow to delete multiple rows in excelexcel macro to compare two columnsadding axis labels in excel