Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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
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
