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

difference between vlookup and hlookupfiltering duplicates in excelrounding numbers chartcomplex excel formulas with examplesucla gmat rangeusing vlookup function in excelvba to remove duplicatesvlookup and hlookup tutorialexcel lookup syntaxdownload microsoft powerpoint 2010 free trialexcel match formulamultiple rows in pivot tablevlookup excel explainedhow to vlookup in excel 2007wingding check markparenthesis excelexcel swap columnsexcel how to vlookuphow to delete doubles in excelmrexcel commicrosoft excel multiple if statementsexcel compare rangesexcel compare columns highlight differencesuse of offset function in excelucla libraries hourscheat sheet for excel formulasvllokup excelexcel application.matchhow to do vlookup in excel 2007unique values in exceltask tracker excelcompound if statement in excelaverage gmat score for uclacool tricks in excelhow do i do a vlookupvlookup exercisesname picker for teacherstax return excel templateexcel chart titlesnested vlookup functionhow to generate a bell curve in exceliserror and vlookupw 4 withholding calculator 2015vlookup blankfree download primo pdf convertercheckmark powerpointhow to insert a tick in word 2010excel auto calculatecheckbox symbol in wordms excel if statementsbetter than vlookupvlookup similarexcel formulas with examples in excel sheethide macros in excelfree trial version of microsoft word 2010excel symbol for does not equalrandbetween no duplicateswhat is vlookup excelhow do you do a histogram in exceloffset function excelexcel formulas multiple ifexcel duplicate recordsucla femba admissionsgaussian distribution excelmicrosoft hup office 2013 full downloaddelete duplicates on excelhow do you do vlookup in excelexcel stacked chartsif clause in excelcmc student webmailcell formatting in excelblank homework chart