Merging two sheets with common column

prerna

New Member
Joined
Aug 11, 2010
Messages
1
Hi,

I have two sheets in a excel file.(S1 & S2). Both common column say EmpID<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p> </o:p>
S1 has EmpID and Fname<o:p></o:p>
S2 has EmpID and Locations, each EmpID has multiple Locations. The Empid of S1 have some common values of S2..<o:p></o:p>
<o:p> </o:p>
I need to merger these two sheets based on Empid, which displays Empid(of S1) and and its Locations from S2.<o:p></o:p>
<o:p> </o:p>
I tried using VLOOKUP() but its takes only single value of Locations. <o:p></o:p>
<o:p> </o:p>
Please help me out<o:p></o:p>
<o:p> </o:p>
Thanks in advance.<o:p></o:p>
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Do you have Access available? This is a simple join using Access. You would import the the two worksheets into Access as tables. Create a query -- join on the common field and then export the query back out to Excel.

Alan
 
Upvote 0
Lenze;
Thanks for the info on MS Query. I have never used it and did a quick google search and found a tutorial. Once set up, it looks a lot like MS Access Query. I am off to learn all about this.

Prerna: I found this tutorial at
http://www.exceluser.com/explore/msquery1_1.htm

You might find this helpful also.

Alan
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top