Microsoft Excel Vlookup Tutorial

How to use vlookup in excel 7 8.

Microsoft excel vlookup tutorial. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. In this vlookup guide we will learn. As a result the vlookup function returns the salary of mia clark first instance. Vlookup works a lot like a phone book where you start with the piece of data you know like someones name in order to find out what you dont know like their phone number.

The vlookup function in excel performs a case insensitive lookup. This argument can be a cell reference or a fixed value such as smith or 21000. Heres an example of how to use vlookup. I use excel 2007 in this video but it works in 200.

For example the vlookup function below looks up mia cell g2 in the leftmost column of the table. Notice how excel displays the cells value of a to the right of the text box. In the lookupvalue text box type c2 in this step were asking excel to look up the contents of cell c2. Vlookup in excel may sound complicated but you will find out that it is a very easy and useful tool once you try it.

This video is a brief guide on how to use the sometimes complex vlookup function in microsoft excel. Look at the example below to understand vlookup. In its simplest form the vlookup function says. For vlookup this first argument is the value that you want to find.

In this video i explain everything you need to know to get started with vlookup for excel. 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. Download the excel file. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel.

So as an example ill enter part numbers the thing i know and find out prices the thing i dont know.