Vlookup In Excel Tamil Tutorial

Vlookup relies on 4 function arguments which are numbered above.

Vlookup in excel tamil tutorial. How to use vlookup in excel 6 7. In this vlookup guide we will learn. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. 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 example the vlookup function below looks up mia cell g2 in the leftmost column of the table. As a result the vlookup function returns the salary of mia clark first instance. How to use vlookup in excel in tamil. 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. The vlookup function is case insensitive so it looks up mia or mia or mia or mia etc. Lets look at the previous example where we had a list of employees stored in a sheet named vlookup which was part of the example file called vlookupxlsx. Complete excel class link.

How to use vlookup in excel 2007 learn computer technology by tamil for free source code and free project please visit.