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:

The result of the above formula will print the result as follows:

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.

Contents

Financial Ratios
Accounting Cycle
Accounting Principles
Financial Accounting Basics
Financial Statements Reporting
Bad Debts
Current Assets
Long-term Assets
Voucher System
Partnership
Depreciation
Work Sheet
Difference Between Reserve and Fund
Accounting for Leases
Capital reduction and reconstruction
Absorption of Company
Amalgamation
Accounting for Installment Sales
Basis of Recording Profit and Loss
Branch Accounting
Construction Contracts
Revenue Recognition
Accounting for Groups
Financial Analysis
Events After the Balance Sheet Date
Deferred Tax
Cost Accounting
Activity Based Costing (ABC)
Throughput Accounting
Relevant Cost
Break Even Analysis
Standard Costing
Inventory Management
Payroll Accounting
Royalty Accounting
Statistics
Master Budget
Salary Income
Microsoft Excel Tutorial
How to Count Number of Records between Two Dates
How to sum values in excel based on a criteria
Finding the first login and last logout time of employees
How to Print Salary Slips Using VLookup Formula in Excel
How to Calculate Net Present Value (NPV) in Excel
Income tax calculation excel sheet for salaried individuals
How to Calculate Pay Back Period in Excel
How to Calculate Declining Balance in Excel Using Formula
How to Calculate Double Declining Balance in Excel
How to Calculate Number of Payments on A Loan In Excel Using NPER
Count the Number of Excel Records That Fall Between Two Dates
How to Count Cells between Two Numbers in Excel
How to Prepare Exam Result in Excel 3D Sum Multiple Worksheets
How to Count Specific Text in Excel
Other Topics
Share or Stock Valuation Model
Financial Management Topics