Using VLOOKUP In Excel

Microsoft Excel 2013 have a huge number of handy functions, many of which go unused by the average user. But If you find yourself frequently needing to consult a table to find the same data, however, you'll probably want to learn how to use VLOOKUP. Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example, if you have a list of products with prices, you could search for the price of a specific item.

We're going to use VLOOKUP to find the Name of the Students. You can see with this have a few name in here but in the real work it will be more than this. Once you learn how to use VLOOKUP, you'll be able to use it with larger, more complex spreadsheets, and that's when it will become truly useful.

For this example I using VLOOKUP for search Student data, after I type the name in search box it will find data that spreadsheet if the match they will show Genter, Score, and Grade.

Now see how we do it : 

This my code how I use in VLOOKUP "=VLOOKUP(F7,A2:D9,2,FALSE)"

The first argument is the name of the students you're searching for, which in this case is Sutdent.

=VLOOKUP(F7     <---- This F7 is search value 

The second argument is the cell range that contains the data. In this example, our data is in A2:D9. 

=VLOOKUP(F7, A2:D9   <---- Cell range that contains the data

The third argument is the column index number. It's simpler than it sounds: The first column in the range is 1, the second column is 2, etc.

=VLOOKUP(F7, A2:D9, 2 <----- Column index number 

The fourth argument should be FALSE because we're only looking for exact matches, . This is our last argument, so go ahead and close the parentheses.

=VLOOKUP(F7, A2:D9, 2,FALSE)

See video : https://goo.gl/PihaUg