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

Exam 77-427 Microsoft Excel 2013 EXPERT
3. Create Advanced Formulas
3.2 Look Up Data with Functions: Use The VLOOKUP Function
graphic1

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 & Reference.

Select VLookup from the function list.

 

Please keep going...