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 most popular Excel books on Amazon
 

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 most common mistakes with VLOOKUP.   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

Click here to view the original source

Screenshots

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:

\n