The Lookup Function Say your company offers a bonus for meeting sales goals. The bonus will be calculated as a percent of the sales.   The best way to calculate the bonus is to look up the answer in a table. Excel calls this the Lookup function. A vertical, or VLookup uses the values in the columns. A horizontal, or HLookup, uses the data in rows.   1. Try it: Create a VLookup Table Go to the Bonus spreadsheet. Add the following labels: In cell C1, type Commission In cell D1, type Bonus In cell F1, type Sales In cell G1, type Percent   Format the Labels Bold. Format Column F for Accounting. Format Column G for Percentage.   Keep going.