Formula -> Function Library>Lookup & Reference->VLookup Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.1. Create formulas: 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.