Click the cell where you want the VLOOKUP formula to be calculated. Click "Formula" at the top of the screen. Click "Lookup & Reference" on the Ribbon. Click "VLOOKUP" at the bottom of the drop-down menu. Specify the cell in which you will enter the value whose data you're looking for.What does the VLOOKUP formula do?
VLOOKUP is one of the formulas you can use to answer questions like this. VLOOKUP searches a list for a value in left most column and returns corresponding value from adjacent columns. So, in our case, we need VLOOKUP to search for Jimmy and return the amount of sales he made from column 3.