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

Use a VLOOKUP function for an exact lookup:

Lesson 3-22 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Use a VLOOKUP function for an exact lookup
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 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 2013 Expert Skills tutorial.How to do a VLOOKUP in Excel.
Description:

This lesson shows how to use VLOOKUP in Excel. The video lesson provides a complete introduction to the VLOOKUP function in Microsoft Excel 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.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email