Vlookup Macro - Need help in running Vlookup for Multiple Columns in different worksheets from Master Excel File

[johnny_raman]

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.

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>

 

[johnny_raman]

Thanks .. i worked it out myself..!!