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

vlookup namesexcel plot bell curvemba case studies examplestext vlookuphow to make a 100 stacked bar chart in excelvlookup tutorial excelcombine formula in exceltax calculator excel sheethlookup sampleadvanced excel tricks pdfhow to use vlookup excel 2007countif not equalpricing model template in excelcheck mark in wingdingsexcel 2007 formulas tutorialassignment due date templateisna vlookup excel 2010correct mark symbolhow to do a normal distribution graph in exceluse of vlookup in excel 2007 with examplehow to create a checkmark in excelautocorrelation coefficient excelcovert pdf to xlsmicrosoft office 2013 student discount $10excel multiple if and statementsexcel tutorial booksxls matchhow to make bar and line chart together in excelvlookup not workinghow to delete rows in excelvlookup function in vbamicrosoft word 2010 free trial downloadexcel vertical lookupsymbol for checkmarkunderstanding vlookupmy ucla edu webmailsensitivity analysis spreadsheetwhat is a nested function in excelmaking histograms in excel 2010random generator excelwhat is the most visited website in the worldhlookup dan vlookupexcel barchartvlookup refmaking a bar graph in excel 2010how to delete duplicates in excel 2010vlookup with vbadelete all duplicatesrandom number generator in vbaindex and match function excelms excel syntaxv look excelwhat does vlookup meanformula to remove duplicates in excelexcelvlookupexcel pivot tutorialvlookup horizontalexcel 2010 vlookup multiple criteriaexcel formula to calculate rangerandom number in vbaformat axis in excelfind duplicate entries in excelexcel match two columns of datahbs case interview guideexcel duplicates formuladata labels in excelvlookup in two different sheetsputting formulas in excelisna formula excelask mr excelthe vlookup functionnested vlookup excelcomparing lists in excel