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

Home -> Font The Lookup Function Say your company offers a bonus for meeting sales goals. The bonus is calculated as a percent of the sales.   The best way to calculate the bonus is with a Lookup function. A vertical, or VLookup uses the values in the columns. A horizontal, or HLookup, uses the data in rows.   Try it: Create a VLookup Before you begin, Insert a new Sheet and rename it Bonus.   Add the following labels: In cell A1, type Sales Rep In cell B1, type Sales Total In cell C1, type Commission In cell D1, type Bonus In cell F1, type Sales In cell G1, type Percent   Format the Labels Bold. Add the names of our sales reps: Alex, Connie, Elizabeth and Niki.