Microsoft Excel Tutorial On Vlookup

Vlookup stands for vertical lookup.

Microsoft excel tutorial on vlookup. Before you paste the data into excel set the column widths for columns a through c to 250 pixels and click wrap text home tab alignment group. For example the vlookup function below looks up mia cell g2 in the leftmost column of the table. 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. 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.

So as an example ill enter part numbers the thing i know and find out prices the thing i dont know. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. How to use vlookup in excel 7 8. 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 the lookupvalue text box type c2 in this step were asking excel to look up the contents of cell c2. 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. In this vlookup guide we will learn. 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 this video i explain everything you need to know to get started with vlookup for excel. The vlookup function in excel performs a case insensitive lookup. Vlookup example at work copy the following data into a blank spreadsheet. This tutorial assumes youve heard about the vlookup function and its benefits but that you dont really know how or when you might use it.

By emily warn mvp bill jelen has created this vlookup tutorial for those of you who have a basic working knowledge of excel but want to improve your skills. In its simplest form the vlookup function says. As a result the vlookup function returns the salary of mia clark first instance.