How To Use VLOOKUP in Excel
How to do a vlookup between two spreadsheets If you know the name of a product, for instance, and you want to quickly determine its price, you can simply enter the product name into Excel and VLOOKUP will find the price for you. To the novice Excel user, however, setting up VLOOKUP can look like an intimidating process -- but it needn't be. Just follow our step-by-step tutorial to start using VLOOKUP today. 1. Click "Lookup & Reference" on the Ribbon. . 2. Click "VLOOKUP" at the bottom of the drop-down menu. 3. Specify the cell in which you will enter the value whose data you're looking for. In this case, our lookup value is H2, since this is where we will input the name of a tournament such as "PGA Championship," so we input "H2" in the lookup_value box of the popup window. Once we've set up VLOOKUP properly, Excel will return the tournament's Total Rating Value in cell H3 when we type the tournament ...