Home Sample Files e-Books Books Wholesale Forums & Support Contact
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Use a VLOOKUP function for an exact lookup:

Lesson 3-22 from: Microsoft Excel 2016 Expert Skills (0 Video Lessons)
Use a VLOOKUP function for an exact lookup
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Before you watch your first video you need to know three things!
1. This is a walk-through and not a stand-alone video lesson
The walk-through is intended to be used only with an e-book or paper book. Read and work through the printed lesson first. Only watch the video walk-through if you have difficulty with it.
2. Video walk-throughs do not have a sound track
Reading out the lesson steps (shown in the captions) wouldn't add any value. If a wordy narrative was added it would bloat the walk-through and make it less useful for its intended purpose.
3. Make sure that you use the interactive transcript and e-book button
Jump straight to the step you need to see using the interactive transcript. window. Just click on the step you need. Play with the other buttons too - you'll never have seen some of the features our player has before.
OK - I’ve got it! Don't show this again.
Back 10 Seconds
Full Screen View
Online Video Course: Microsoft Excel 2016 Expert Skills
Session: Session 3: Advanced Functions
Lesson: Lesson 3-22 Use a VLOOKUP function for an exact lookup Thumbnail for the lesson: How to use VLOOKUP in Excel.  Lesson 3-22 from the Excel 2016 Expert Skills tutorial.How to do a VLOOKUP in Excel.

This lesson shows how to use VLOOKUP in Excel. The video lesson provides a complete introduction to the VLOOKUP function in Excel 2016 formulas. In this lesson's example, a VLOOKUP function is used to search for a stock code number in a worksheet and return the corresponding item's description and price. This lesson explains best practices for VLOOKUP functions and introduces the difference between Exact and Inexact lookups.