Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.1. Create formulas: VLookup Autofill the VLookup 6. Try This: AutoFill the Formula Select Cell C2. Use the AutoFill handle to copy to formulas to Cells C3 through C5.   What Do You See? The VLookup function compares how much our sales rep made and determines the best percent for the commission.   The equation in Cell C5 would be: =VLOOKUP(B5,Sales,2)   Memo to Self: This is a good place to Save your work. Please name the spreadsheet: Sales 2010 Complete.