VenkateshM75
New Member
- Joined
- Mar 9, 2012
- Messages
- 1
Need your help in the following matter.
I have a master data excel workbook with 5000 records and 90 columns.
There is also another Reporting workbook where I need to populate information about 250 resources. This sheet has 25 columns out of which 20 columns are to be populated with values from the Master workbook, corresponding to the 250 names.
Currently I do a vlookup for each column and populate the reporting workbook.
Is there a easier mechanism?
Example.
Master (90 columns)
Emp Id Name DOJ Sal Address Phone Skill Skill2 Project ...
1 AA 12/12 200 221/B 12121 C D Proj1
2 ...
3... CC 11/11 .. Proj 2
3... CC 11/11 .. Proj 3
4500...
Report book (25 columns only for 250 employees of a group whose ids are known)
Emp id Name Project Skill Skill2 DOJ
1
2
4
7
...
250
Is it possible to parallelise vlookups based on id so that all other matching columns are populated at one instance instead of multiple vlookups?
Please help
Venkatesh
I have a master data excel workbook with 5000 records and 90 columns.
There is also another Reporting workbook where I need to populate information about 250 resources. This sheet has 25 columns out of which 20 columns are to be populated with values from the Master workbook, corresponding to the 250 names.
Currently I do a vlookup for each column and populate the reporting workbook.
Is there a easier mechanism?
Example.
Master (90 columns)
Emp Id Name DOJ Sal Address Phone Skill Skill2 Project ...
1 AA 12/12 200 221/B 12121 C D Proj1
2 ...
3... CC 11/11 .. Proj 2
3... CC 11/11 .. Proj 3
4500...
Report book (25 columns only for 250 employees of a group whose ids are known)
Emp id Name Project Skill Skill2 DOJ
1
2
4
7
...
250
Is it possible to parallelise vlookups based on id so that all other matching columns are populated at one instance instead of multiple vlookups?
Please help
Venkatesh