Search TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
Home
Video Tutorials
Free Macros
Keyboard Shortcuts
Forum
Contact
Main Menu
  • Home
  • Video Tutorials
    • Arrays
    • Charts & Graphs
    • Financial Functions &
    • Models
    • Formatting
    • Formulas
    • Data Analysis Tools
    • Import / Export / Link
    • Lists & Forms
    • Macros
    • Printing
    • Security
    • Tips & Tricks
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
Tips
Create your first Formula
Create your first Chart or Graph
Password protect your Workbook
Hide Rows, Columns, and Tabs
Using Conditional Formatting
Tutorials: Formulas

VLOOKUP() - What is it and how to use it - Part 1

Part one | Part two

How to use the VLOOKUP() function and what it is. This tutorial will explain how the VLOOKUP() function works and why you might want to use it. It will save you time, and, once you get the hang of it, it is not too hard. Here is a basic presentation of what it can do and two examples using the VLOOKUP() function.

Topics Covered
     VLOOKUP() - What it does and        how to use it
     Two examples of when to use        VLOOKUP()
     How it saves you time
   Difficulty:         Intermediate
   Video:               Yes
   Spreadsheet:     Yes      Download
Got a Question? Ask it Here in the Forum.
Most Recent Tutorials
Nov. 25
Group and Ungroup Cells in Excel (Easily Hide and Unhide Data)
Absolute and Relative Cell References & INDIRECT() Function
Sep. 20
Bond Pricing and Valuation
Calculate the Future Value of a Retirement or Savings Plan
Calculate the Net Present Value of Future Cash Flows
Build a Loan/Mortgage Payment Calculator
Calculate Interest and Principal Payments on a Loan
Sep. 10
FIND() LEN() Functions - Extract Text from Cells - Intermediate
FIND() LEN() Functions - Extract Text from Cells - (2 Parts) - ADVANCED
VLOOKUP() Between Separate Worksheets and Workbooks
Contact | Privacy Policy | Disclaimer
Copyright© 2008 TeachExcel.com