Formula -> Function Library>Lookup & Reference->VLookup

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.1. Create formulas: VLookup

The Lookup Function

Microsoft Excel has a a collection of Lookup and Reference Functions in the Function Library. Here are the steps to create a VLookup formula.

 

4. Try This: Insert a VLookup Function

Select Cell C2.

Go to Formula -> Function Library.

Go to Lookup and Reference.

Select VLookup from the function list.

 

Please keep going...