johnny_raman
New Member
- Joined
- Mar 26, 2014
- Messages
- 22
Hi..
I have a master excel file (Table 1) which has all the required details based on an unique ID. Need help in creating a code which could help me in running vlookup against multiple columns in a fresh excel file (Table 2) which has the same unique IDs.
There are multiple worksheets as such with Unique ID which needs to pick data through Vlookup.
Below table is just for eg: Table 1 is my source data and Table 2 is where i need to run vlookup for multiple columns.
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" width="50"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" width="35"> <col style="width: 48pt;" width="64"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" width="50"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" width="35"> <tbody>
</tbody>
Any help is much appreciated.
Thanks,
Johnny
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 189pt; mso-width-source: userset; mso-width-alt: 9216;" width="252"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;" width="93"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" width="54"> <col style="width: 48pt;" width="64"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 189pt; mso-width-source: userset; mso-width-alt: 9216;" width="252"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" width="50"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" width="54"> <tbody>
</tbody>
I have a master excel file (Table 1) which has all the required details based on an unique ID. Need help in creating a code which could help me in running vlookup against multiple columns in a fresh excel file (Table 2) which has the same unique IDs.
There are multiple worksheets as such with Unique ID which needs to pick data through Vlookup.
Below table is just for eg: Table 1 is my source data and Table 2 is where i need to run vlookup for multiple columns.
TABLE 1 | TABLE 2 | |||||||||||||||
Unique ID | Name | Lead | Manager | 0 to 10 | 11 to 30 | 30 to 60 | Units | Unique ID | Name | Lead | Manager | 0 to 10 | 11 to 30 | 30 to 60 | Units | |
118112648 | Jessy Thomas | John | Robert | 1 | 0 | 6 | 191 | 118112648 | Jessy Thomas | John | Robert | |||||
118130109 | Sam Vicky | Mac | Layla | 2 | 8 | 7 | 254 | 118130109 | Sam Vicky | Mac | Layla | |||||
118130307 | Riya | John | Robert | 0 | 2 | 3 | 52 | 118130307 | Riya | John | Robert | |||||
118130383 | Tom Hardy | Mac | Layla | 0 | 118130383 | Tom Hardy | Mac | Layla | ||||||||
118112808 | Rick | Richard | Robert | 0 | 0 | 5 | 244 | 118112808 | Rick | Richard | Robert | |||||
118115540 | Tracy Mary | Richard | Robert | 0 | 118115540 | Tracy Mary | Richard | Robert | ||||||||
118115588 | Steevan | John | Robert | 2 | 0 | 1 | 228 | 118115588 | Steevan | John | Robert |
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" width="50"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" width="35"> <col style="width: 48pt;" width="64"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" width="50"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;" width="35"> <tbody>
</tbody>
Any help is much appreciated.
Thanks,
Johnny
TABLE 1 | TABLE 2 | |||||||||||||||||||||
Unique ID | Name | Lead | Manager | 0 to 10 | 11 to 30 | 30 to 60 | 1000 to 2000 | 2000+ | Hold To Wrap | Units | Unique ID | Name | Lead | Manager | 0 to 10 | 11 to 30 | 30 to 60 | 1000 to 2000 | 2000+ | Hold To Wrap | Calls Ans | |
118112648 | Tanveer Pasha | John | Robert | 1 | 0 | 6 | 10 | 2 | 1 | 191 | 118112648 | Tanveer Pasha | John | Robert | ||||||||
118130109 | Som Subhra Bhattacharya | Mac | Layla | 2 | 8 | 7 | 29 | 0 | 2 | 254 | 118130109 | Som Subhra Bhattacharya | Mac | Layla | ||||||||
118130307 | Roopali Bachaspati Mayum | John | Robert | 0 | 2 | 3 | 7 | 0 | 0 | 52 | 118130307 | Roopali Bachaspati Mayum | John | Robert | ||||||||
118130383 | shashi kumar | Mac | Layla | 0 | 118130383 | shashi kumar | Mac | Layla | ||||||||||||||
118112808 | Christina Palle | Richard | Robert | 0 | 0 | 5 | 13 | 0 | 3 | 244 | 118112808 | Christina Palle | Richard | Robert | ||||||||
118115540 | B S Sai Ranganath | Richard | Robert | 0 | 118115540 | B S Sai Ranganath | Richard | Robert | ||||||||||||||
118115588 | Chethan Halugowdanakatte, Puttarangappa | John | Robert | 2 | 0 | 1 | 21 | 1 | 2 | 228 | 118115588 | Chethan Halugowdanakatte, Puttarangappa | John | Robert |
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 189pt; mso-width-source: userset; mso-width-alt: 9216;" width="252"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;" width="93"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" width="54"> <col style="width: 48pt;" width="64"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 189pt; mso-width-source: userset; mso-width-alt: 9216;" width="252"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" width="50"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" width="46"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="2" width="53"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;" width="41"> <col style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;" width="81"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;" width="54"> <tbody>
</tbody>