For Example in one file you have employee master data like Employee No., Name, Bank Account No. and in another file employee salary details with employee No. for a particular month.
From the available information in the two files, if you want to prepare a salary statement with bank account number which is to be sent to bank for payment, you can use the VLOOKUP function and combine the information in two files based on the employee Number.
|click to enlarge the picture|
In the given example, to update the salary details in Payment Statement the formula will search the employee number in Pay roll data table and return the value in 6th column for matching employee number. If there are no records matching for the employee number, it will show the error.