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 VLookup Arguments 5. What Do You See? Excel will prompt you to fill in the Function Arguments. Here are some answers.   Lookup_Value: The first argument asks, “Where is the data?” In our example, Alex's total is in cell B2. Click on cell B2. Table_array: The second argument wants to know, “Where is the lookup table?” You can type the name, sales, for the range or use the red, white and blue lookup button to go to highlight cells F1 through G5. Col_index_num: The third argument needs to identify where the answers are. In our two column Sales array, the percents are located in Column 2. Click OK.