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

how to insert check mark in excel 2007how do you get a tick in excelexcel vba create rangehow to compare two columns of data in excelexcel macro worksheetvlookup different sheetscombine hlookup and vlookupfreeze formula excelucla summer parkingucla anderson loginexcel if statement multiple conditionsremoving duplicates excelvlookup hlookup in excelexcel vlookup range lookuphow to create macros in excelexcel formula iserrormicrosoft excel lookup functionhbs case methodcompare two pivot tablestroubleshooting vlookupexcel spreadsheets formulas and functionsexcel compare multiple columnsindex formula in excel 2007excel finance templatehow to find duplicate values in exceldifference between filtering and sortingexample of hlookupinsert tick box in excelyaya name generatorinsert tick markduplicate values in excelvlookup testhow to write if statements in excelexcel make line graphvba excel random numbergpa average for uclasymbol for check markappend formula in excelexcel task list trackerexcel count occurancesexcel delete row shortcutvlookup different sheetshow to make a line graph on exeldelete columns in excelcell reference range exceltick symbol on wordbar and line chart in excelvlookup function with exampleplot gaussian distribution excelucla phone directorydeloitte consulting vaultexcel models for forecastingucla ackerman bookstorenormal distribution probability excelexcel lookup functionoffset vbahow to insert brackets in excelmy chart tchpayment template excelfc seoul jerseymba candidate resumevlookup in excel for dummieshow to insert a checkmark into excelhow to change axis labels in excel 2010task planner excel templatevlookup within an if statementvlookup excel multiple sheetsexcel troubleshootdelete repeated rows in excelucla mba salaryv look ups excelzs associates internshipexcel shortcut filtervlookup in exelmultiple if statements excelhow to draw a normal distribution curve in excel