Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

Formulas -> Insert Function -> Lookup and Reference

The Lookup Function

Select cell C2 and go to the Formulas tab. Click on Insert Function. From the category list, choose Lookup and Reference. Now, find VLookup at the bottom of the function list.

 

  Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas

  3.5. Look up data using a formula

  3.5.1.   Using VLOOKUP and HLOOKUP : Use VLOOKUP to locate values