Video: VLOOKUP—What it is, and when to use it
![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9. Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/msn_video_widget.gif)
Discover more Excel training at LinkedIn Learning
Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person's name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.
Goals
After completing this course you will be able to:
-
Enter VLOOKUP arguments in a formula.
-
Use VLOOKUP to find values in Excel lists or tables.
-
Avoid VLOOKUP errors.
Before you begin
You should already be familiar with Excel formulas. If you are not, take this course: Get to know Excel 2010: Create formulas.
Download this course
Offline version (31 MB)
Practice
We're sorry, the practice session is not available.
Quick reference card
See the quick reference card for a brief, printable reminder of the key points in this course.
See more courses on Microsoft Office Training.
No comments:
Post a Comment