TeachExcel.com
Video Tutorials, Macros, Shortcuts, and More...
TE
Home Online Excel Classes Downloadable Tutorials & Guides Consulting Services Excel Help Now Contact Us
Excel Tips Excel Blog Excel Video Tutorials Excel Macros Forum
Video Tutorials
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
  • New Excel Interface & Features
  • Getting Started with Excel 2007
  • Intro. to Formulas and Functions
  • Intermediate Formulas/Functions
  • Printing - Formatting - Saving
  • Sorting, Filtering, & Tables
  • Data Consolidation & Retrieval
  • Security in Excel 2007
Tutorials: Lookup & Search Functions in Excel
Featured Tutorial
Dynamically Update Drop-Dowm Menus in Excel
Featured Macro
Delete Empty Rows in Excel

Excel Lookup/Search Tip 4 - Vlookup Explanation 3 - Vlookup to Assign Grades to Students

Bookmark and Share
View all of our Excel Video Tutorials on our New YouTube Channel HERE.

Traditional VLOOKUP() function example in Excel. This tutorial teaches you how to assign grades to students using the Vlookup function in Excel. You will learn how to use the approximate setting of the range lookup for the vlookup. This is the last classic example of a basic use for the Vlookup function in Excel and is a walkthrough example of how to use Vlookup.
   Topics Covered
VLOOKUP() function in Excel.
Assign grades to students.
Search a table in Excel.
Learn how to use VLOOKUP().
   Difficulty:         Intermediate
   Video:               Yes
   Spreadsheet:     Yes
Download Here:     1
Got a Question? Ask it Here in the Forum.
Contact | Privacy Policy | Disclaimer
Copyright© 2009 TeachExcel.com