In large organizations, the office staff and labour are found in huge quantity. In order to keep track of their attendance up to date is not an easy task. If the number of employees touches thousand, then it become the headache of the human resource staff to process the salaries and print the slips.
Lets suppose that ABC is a shoe manufacturing concern. It has around 2,000 employees, following is the extract from its Excel Payroll sheet maintained in Sheet 1:
S. NO | Name | Employee ID | Basic Salary | Over time | Total Salary |
1 | Ahmed | 001 | 30,000 | 3,000 | 33,000 |
2 | Salman | 002 | 25,000 | 2,000 | 27,000 |
3 | Jagdesh | 003 | 35,000 | 1,000 | 36,000 |
4 | Kiran | 004 | 20,000 | 5,000 | 25,000 |
5 | Jose | 005 | 28,000 | 4,000 | 32,000 |
6 | Allan | 006 | 22,000 | 6,000 | 28,000 |
7 | Martin | 007 | 23,000 | 7,000 | 30,000 |
Now, we will prepare payroll slips using the Vlookup fucntion in excel in Sheet 2 using the formula shown below:
![](http://easyaccounting101.com/images/How-to-Print-Salary-Slips-Using-VLookup-Formula-in-Excel-1.jpg)
The result of the above formula will print the result as follows:
![](http://easyaccounting101.com/images/How-to-Print-Salary-Slips-Using-VLookup-Formula-in-Excel-2.jpg)
Here, we just input the S. No of each row record in C2 cell, then the formuloa will fetch up all the data based on the value of C2 in Sheet 1. We entered 2, 3, 4, 5 & 6 to tell the Ms Excel that from which column, the formula retrieves the result. VLOOKUP is invaluable Micrsoft Excel Formula which speeds up the genjeration of various types of reports.