Excel Forum

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

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

Got a Question? Ask it Here in the Forum.