(Note: In honor of VLOOKUP Week, March 25-31, we’re re-publishing this round-up of VLOOKUP resources on Office.com and other places. Thought some of you might want to brush up on your skills before you write that post.)
People are crazy for Excel’s VLOOKUP function, and why not? Among other things, VLOOKUP is known for its rugged good looks and unparalleled martial arts ability.
In all seriousness, VLOOKUP is one of the most widely used, versatile functions in Excel. You typically use it to quickly look up and extract specific bits of information from a big list of data. In the following example, I’ve instructed VLOOKUP to search for a page ID on another worksheet, find a corresponding page name, and plunk that page name back in the cell where I entered the formula. (Yes, “plunk.”)
Since VLOOKUP is one of the top search queries on Office.com, we gather you have some questions about how to use it. Here’s a compilation of resources that can help you learn or troubleshoot.
NEW TO VLOOKUP?
If you don’t know much about VLOOKUP, start here.
|Resource||What is it?|
|VLOOKUP: What is it, and when to use it||Video-based training course that contains detailed information about VLOOKUP, including a practice file and a Quick Reference Card.|
|VLOOKUP function||Help article that describes the formula syntax in detail and provides examples. Just the facts, ma’am.|
|VLOOKUP refresher||Printable card for those who use VLOOKUP infrequently and thus need help remembering the function arguments (in plain English, the information between the parentheses that tells the function what to do).|
|Excel Lookup Functions and Formulas – Beginning to Advanced||Video series that covers all the lookup functions in Excel, not just VLOOKUP. (If you don’t know about Mike Girvin’s “ExcelIsfun” video series on YouTube, take a look and see what you think. I find these videos to be immensely helpful.)|
HAVING TROUBLE MAKING THINGS WORK?
Once you dig in, you may run into issues. These resources can help.
|Resource||What is it?|
|VLOOKUP troubleshooting tips||Printable card that explains techniques for avoiding or managing #N/A errors.|
|Solutions to three common problems when using VLOOKUP||Post by MVP Greg Truby that addresses these very common questions:
|Beyond VLOOKUP: INDEX and MATCH||Article by MVP Bill Jelen that explains a little more about that last bullet point above–that VLOOKUP always uses the first column in a lookup table as the starting point. If that won’t work for your situation, you can use INDEX and MATCH instead of VLOOKUP.|
|Microsoft Answers||Free tech support forum where you can ask specific questions about VLOOKUP and get answers from Excel MVPs and other Excel users. For example, here are existing threads about multiple VLOOKUPsand conditional VLOOKUPs.|
No doubt, there are countless useful articles and tutorials out there. If you have a personal favorite, or a good tip, please feel free to share it with us.