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

Lookup

That’s it. The VLookup function will compare how much our sales rep made and determine the best percent for the commission.

 

The final equation looks like this:

=VLOOKUP(B2,Sales,2)

Insert -> Function ->VLookup

 

  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