Compensation Mgt, Performance Appraisal &
Manager Human Resource
Manager - Hr
Human Resource Management
Please look after the below link.
If you have any problem feel free to ask.
21st May 2012 From India, Ahmadabad
whenever you have to match the column records of two sheets, Vlookup can be useful for the same. And it can be use as follow:
Sheet 1: Column A
Clmn.A: Name Clmn B:Age
Clmn.A: Name Clmn B:BOD ClmnC:Age
A1:C3=Existing Sheet range, based on which detail, require data should get
Sheet2: select the sheet from where you need to fetch the data
A1:C3: Entire Range from where data should fetch=A=Name,B-DOB,C-Age)
3: Number of column where the data mention (i.e Age)
It's confusing but you may try.
22nd May 2012 From India, Ahmadabad
As I have mentioned, it can be very helpful while cross check the detail and reconfirm the work. I had well tried to explain in my previous post so try to get it understand from it as it's difficult to make it understand in written.
23rd May 2012 From India, Ahmadabad