How To Apply Vlookup In Excel 2010

By creating a sample table generally referred as lookup table you can extract info from it and compare it with the desired field to yield required results.

How to apply vlookup in excel 2010. The vlookup function in excel performs a case insensitive lookup. For example the vlookup function below looks up mia cell g2 in the leftmost column of the table. The value you want to look up must be in the first column of the range of cells you specify in the tablearray argument. Select it an click ok.

Vlookup stands for vertical lookup used to find specific data from the datasheet. As a result the vlookup function returns the salary of mia clark first instance. Excel vlookup function can be used when you need to look up the values in the specific table and check it against the other data fields for comparison purpose. Lookup value the cell across from which the data that you want to look up is in.

For example if you want to look up data in cell f3 your lookup value will be in the third row of the spreadsheet. The value you want to look up. Vlookup is the second one in the list. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc.

For example if table array spans cells b2d7 then your lookupvalue must be in column b. The vlookup formula consists of four main parts each of which refers to a piece of information in your spreadsheet. Jelen is author of the five star reviewed guerilla data analysis using microsoft excel co author of vba and macros for microsoft excel co author of pivot table data crunching and author of. Lookupvalue can be a value or a reference to a cell.