Vlookup Excel 2010 Tutorial For Beginners

Select cell e4 and enter the vlookup function shown below.

Vlookup excel 2010 tutorial for beginners. Create two named ranges. 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. In this vlookup guide we will learn. 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.

Vlookup formula is the most used formula in excel and is used to lookup data in ms excel. Excel vlookup function in its basic form can look for one lookup value and return the corresponding value from the specified row. 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.

Download the excel file. Example 9 using vlookup with multiple criteria. The last item rangelookup 4 is optional and can be blank. 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.

In this video i explain everything you need to know to get started with vlookup for excel. The function is available in all versions of excel 2019 excel 2016 excel 2013 excel 2010 excel 2007 and lower. Download link httpbitly2gwi6i0 vlookup formula is very easy us. But often there is a need to use vlookup in excel with multiple criteria.

The syntax for the vlookup function is as follows. Suppose you have a data with students name exam type and the math score as shown below.