Lookup Tutorial Excel 2013

Youll probably find this vlookup training very useful if you find yourself constantly needing to.

Lookup tutorial excel 2013. 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. Easy and simple way to learn vlookup vertical lookup in excel 2013. Just follow these 10 steps on how to use vlookup in excel 2013 and start using it today. Click the cell where you want the vlookup formula to be calculated and appear.

Download the excel file. 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. Open a document with a.

In this video i explain everything you need to know to get started with vlookup for excel. For example if table array spans cells b2d7 then your lookupvalue must be in column b. Microsoft excel 2013 has a numerous amount of useful tools and functions. Microsoft excel 2013 boasts a huge number of handy functions and utilities many of which go unused by the average user.

This tutorial contains references to function like named ranges. Select cell e4 and enter the vlookup function shown below. The value you want to look up. This process entails finding data in a vertically inclined table that is associated with a specific value which you enter.

The value you want to look up must be in the first column of the range of cells you specify in the tablearray argument. Many people shy away from vlookup initially but once you learn how to use vlookup function in excel 2013 youll be able to make the most of this powerful feature. Just follow our step by step tutorial on how to use vlookup in excel today. Lookupvalue can be a value or a reference to a cell.

Vlookup is one of the most useful formulas i. When using the vlookup function in excel you can have multiple lookup tables. The average user doesnt seem to take advantage of them either. 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.

For a great introduction to excel check out the excel 2013 for dummies video training deluxe edition course.