When in Doubt, Look it Up Every job has something that you need to look up. In automotive design there are lists and more lists of parts, part numbers, sizes and tolerances. In medical and dental care, there are lists of procedure codes. You can use Microsoft Excel to look up the right answer.   In our little company, Charlotte's Website, we need to calculate the commission for our sales representatives. The spreadsheet should compare the sales amount to the numbers in a Bonus table. The key to this formula is creating and naming a Lookup Table. This lesson will demonstrate Vlookup and HLookup Tables. Start -> All Programs ->Microsoft Office -> Excel