Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.2 Look Up Data with Functions: Use The VLOOKUP Function Formula -> Function Library>Lookup & Reference->VLookup

Autofill the VLookup 6. Try This: AutoFill the Formula Select Cell C2. Use the AutoFill handle to copy this formula 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 2013 Complete EAN, where EAN are your initials.