Vlookup Excel 2013 Tutorial Pdf

1 the document provided by youthtruth that contains student ids and login codes well call this sheet 1.

Vlookup excel 2013 tutorial pdf. Using vlookup to match student ids login codes to student names. Select cell e4 and enter the vlookup function shown below. When using the vlookup function in excel you can have multiple lookup tables. This is the default method if you dont specify one.

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. A logical value that specifies whether you want vlookup to find an approximate or an exact match. In this vlookup guide we will learn. The average user doesnt seem to take advantage of them either.

Ms excel has large number of functions and utilities which an average user forget to use them. To get started you will need the following two excel documents. For a great introduction to excel check out the excel 2013 for dummies video training deluxe edition course. You can use the if function to check whether a condition is met and return one lookup table if true and another lookup table if false.

How to use vlookup in excel 6 7. Microsoft excel 2013 has a numerous amount of useful tools and functions. This step by step tutorial will demonstrate how to match student ids and login codes to student names. The functions in excel allow you to sort and retrieve data from large spreadsheets using formulas like the lookup formulas in excel.

Excel is a powerful way of creating storing and analyzing lists of data for business purposes. Create two named ranges. The last item rangelookup 4 is optional and can be blank. One tool in particular is the vertical lookup or vlookup which looks at the vertically aligned tables and quickly finds the data that youre looking for.

Easy and simple way to learn vlookup vertical lookup in excel 2013. This also applies for excel 2010 and 2007. Vlookup formula in excel with example pdf vlookup tutorial. 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 is one of the most useful formulas i. We will use the vlookup function to lookup specific data and then we will create a function to allow others to find data quickly and easily by selecting an item. Youll probably find this vlookup training very useful if you find yourself constantly needing to. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel.

Vlookup relies on 4 function arguments which are numbered above.