Tutorial On Vlookup In Excel 2010

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.

Tutorial on vlookup in excel 2010. I thank you for reading and hope to see you next week. Now we will create the vlookup formula that will translate the a pcode in cell c2 to the description found from the party codes worksheet. For instance we have included a student grading datasheet containing fields. 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.

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. The vlookup function in excel performs a case insensitive lookup. The last item rangelookup 4 is optional and can be blank. Name course and marks.

How to use vlookup in microsoft excel 2010 from power excel 2010 with mr. Approximate match 1true assumes the first column in the table is sorted either numerically or alphabetically and will then search for the closest value. So as an example ill enter part numbers the thing i know and find out prices the thing i dont know. For example the vlookup function below looks up mia cell g2 in the leftmost column of the table.

The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. Now we will add new column grade which will contain grades secured by the students. As a result the vlookup function returns the salary of mia clark first instance. The v in vlookup stands for vertical.

Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. In the next part of our tutorial we will discuss advanced vlookup examples that will teach you how to vlookup multiple criteria return all matches or nth occurrence look up across multiple sheets with a single formula and more. How to use vlookup in excel 6 7. Thats how to use vlookup in excel at the basic level.

Vlookup relies on 4 function arguments which are numbered above. 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. A logical value that specifies whether you want vlookup to find an approximate or an exact match.