Microsoft Excel Tutorial For Vlookup

Heres an example of how to use vlookup.

Microsoft excel tutorial for vlookup. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. As a result the vlookup function returns the salary of mia clark first instance. Vlookup is an extremely useful function for finding information in one column and then returning information in a column to the right in the same row. In other words it allows you to find look up a value from one column of data and returns its respective or corresponding value from another column.

Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. 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. Vlookupb2c2e73true in this example b2 is the first argumentan element of data that the function needs to work.

Vlookup what you want to look up where you want to look for it the column number in the range containing the value to return return an approximate or exact match indicated as 1true or 0false. In this vlookup guide we will learn. As the name specifies vlookup is a built in excel function that helps you look for a specified value by searching for it vertically across the sheet. Learn how to utilize excels vlookup function to simplify your data search.

In its simplest form the vlookup function says. Vlookup in excel may sound complicated but you will find out that it is a very easy and useful tool once you try it. In the parentheses enter your lookup value followed by a comma. I use excel 2007 in this video but it works in 200.

Use vlookup in the formula bar type vlookup. Lets look at an example vlookup is often used to re organize data that exists in a pivot table. This argument can be a cell reference or a fixed value such as smith or 21000. The vlookup function in excel performs a case insensitive lookup.

This can be an actual value or a blank cell that will hold a value. Vlookup stands for vertical lookup. Notice how excel displays the cells value of a to the right of the text box.