VLOOKUP Quick Reference Guide From Microsoft

by Matthew Kuo on January 9, 2016

in Database Theory, Excel, Formula Writing

To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the

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 detail about VLOOKUP’s syntax, including an example of a VLOOKUP formula and some detail on the range lookup function at the end of the syntax.  However, it doesn’t really cover error checking or the .   So if you have an error that you’re dealing with, you should go to the links that I referenced.

Click here to download the VLOOKUP Quick Reference Guide


Below are screenshots from the guide:

VLOOKUP Quick Reference 01

VLOOKUP Quick Reference 02

VLOOKUP Quick Reference 03

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post:

Related pages

excel shortcut for paste specialprofessional graphs in exceldelete a row in excel shortcuthow to match columns in exceleasy excel shortcutschart legend excelonline name randomizervlookup won t workexcel 2007 formulas tutorialexcel formulas & functionsvlookup return multiple columnsindexing formulaoffset formula excelif cell contains text then excelgaussian random number generatorexcel vba averageexcel formula less than or equal totornado chart excelmacro formula excelhow to create a histogram in excel 2013sumproduct index matchduplicate numbers in excelfuzzy matching excelv lookup tutorialvlookup and hlookup togetherucla grading scaleucla discount ticketshow to calculate bin widthhow to lookup in excelexcel leading zeros formulahow to get tick mark in excelexcel compare cell valuesformula vlookup in exceltick for excelvba nested ifkinross gym uclahomework tracking sheetthe goal a process of ongoing improvementhow to create bar and line chart in excel 2010types of errors in ms excelnormal distribution curve in excelrandom password generator excel formulaexcel vba vlookuphow to do vlookupexcel range lookupzs associates india reviewhlookup in excelvlookupshbs case solutionshow vlookup works in excelexcel if formula multiple conditions examplesexcel hlookup exampleproject tracking template excel 2010academic probation uclatrue or false formula in excel 2007excel bracket templatehow to create an histogram in excelinventory excel templatesnormal dist excelremove duplicates formuladeleting duplicates in excelsolver excel tutorial step by stepfind duplicates in excelexcel ranges in formulasdelete duplicate data excelhow to find duplicate values in two columns in excelhow to do a vlookup on excel 2010remove doubles in excellearn vlookup in excel 2007shortcut of excelexcel 2013 stacked bar chartexcel formula for vlookupif cell contains text then excelexcel pivotingexcel randmicrosoft excel vlookupnested ifs in excelto find duplicates in excel