Tutorial Vlookup Excel 2010

Vlookup lookupvalue tablearray colindexnum rangelookup for example.

Tutorial vlookup excel 2010. Enter the cell reference of. Use the vlookup function to look up a value in a table. In the colindexnum field type 2. Use vlookup instead of hlookup when your comparison values are located in a column to the left of the data that you want to find.

The vlookup function follows the nearly identical syntax. As a result the vlookup function returns the salary of mia clark first instance. Vlookup searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. This can be an actual value or a blank cell that will hold a value.

How to use vlookup in excel 9 10. Now we will add new column grade which will contain grades secured by the students. Vlookupa2a10c202true vlookupfontanab2e72false vlookupa2client detailsaf3false. Launch excel 2010 and open a datasheet on which you want to apply vlookup function.

Here are the steps. Vlookuplookupvaluetablearraycolindexnumrangelookup in both functions the lookupvalue argument is the value that you want to look up in the table and tablearray is the cell range or name of the table that contains both the value to look up and the related value to return. Step 1 click on the cell where the vlookup function needs to be applied ie. For instance we have included a student grading datasheet containing fields.

For example the vlookup function below looks up mia cell g2 in the leftmost column of the table. This is our index column from the party codes worksheet that contains the descriptions of the political parties. The vlookup function in excel performs a case insensitive lookup. Step 3 enter the arguments.

Step 2 enter vlookup in the cell. In the parentheses enter your lookup value followed by a comma. In the formula bar type vlookup. As before excel builds the cells formula as we add the function arguments and shows the value it read.

The v in vlookup stands for vertical. In the parenthesis enter the set of arguments for the above instance. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. H2 enter your table array or lookup table the range of data you want to search and a comma.