How To Use Vlookup In Excel 2010 Step By Step With Example

Learn how to use index match in this excel tutorial.

How to use vlookup in excel 2010 step by step with example. Vlookup is an excel function. Index returns the value of a cell in a table based on the column and row number and match returns the position of a cell in a row or column. 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. Tell the function what to lookup.

Understand each aspect of the vlookup formula. As a result the vlookup function returns the salary of mia clark first instance. In the lookupvalue text box type c2 in this step were asking excel to look up the contents of cell c2. For example the vlookup function below looks up mia cell g2 in the leftmost column of the table.

Lookup value the cell across from which the data that you want to look up is in. Learn how to them in this guide instead of vlookup. Vlookup stands for vertical lookup used to find specific data from the datasheet. The vlookup function in excel performs a case insensitive lookup.

This helps you check your entries. Using the vlookup function in excel 2010 basic example. 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. Instructions in this article apply to excel for microsoft 365 excel 2019 excel 2016 excel 2013 excel 2010 excel for mac and excel online.

The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. How to use vlookup in excel 7 8. For example if you want to look up data in cell f3 your lookup value will be in the third row of the spreadsheet. This article will assume that the reader already has a passing understanding of excel functions and can use basic functions such as sum average and today.

The value you want to look up. The vlookup formula consists of four main parts each of which refers to a piece of information in your spreadsheet. The value you want to look up must be in the first column of the range of cells you specify in the tablearray argument. In this step we tell excel what to look for.

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. For example if table array spans cells b2d7 then your lookupvalue must be in column b. Find information in a database with vlookup in the image shown above vlookup is used to find the unit price of an item based on its name. In its most common usage vlookup is a database function meaning that it works with database tables or more simply lists of things in an excel worksheet.