Results 1 to 5 of 5

Merging two sheets with common column

This is a discussion on Merging two sheets with common column within the Excel Questions forums, part of the Question Forums category; Hi, I have two sheets in a excel file.(S1 & S2). Both common column say EmpID S1 has EmpID and ...

  1. #1
    New Member
    Join Date
    Aug 2010
    Posts
    1

    Default Merging two sheets with common column

    Hi,

    I have two sheets in a excel file.(S1 & S2). Both common column say EmpID

    S1 has EmpID and Fname
    S2 has EmpID and Locations, each EmpID has multiple Locations. The Empid of S1 have some common values of S2..

    I need to merger these two sheets based on Empid, which displays Empid(of S1) and and its Locations from S2.

    I tried using VLOOKUP() but its takes only single value of Locations.

    Please help me out

    Thanks in advance.

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    42.28188; -87.88432
    Posts
    2,644

    Default Re: Merging two sheets with common column

    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
    Alan Sidman
    Win 7--Office XP, 2007, 2010

    Be Kind--Use Code Tags. Highlight your code and click on the # sign at the top of the thread window.


  3. #3
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: Merging two sheets with common column

    You can do the same in Excel using MSQuery

    lenze
    If you have to tell your boss you're good with Excel, you're NOT!!
    All I know about Excel I owe to my ignorance!
    Scotch: Because you don't solve great Excel problems over white wine

  4. #4
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    42.28188; -87.88432
    Posts
    2,644

    Default Re: Merging two sheets with common column

    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
    Alan Sidman
    Win 7--Office XP, 2007, 2010

    Be Kind--Use Code Tags. Highlight your code and click on the # sign at the top of the thread window.


  5. #5
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690

    Default Re: Merging two sheets with common column

    My friend Tushar has a good tutorial here.

    lenze
    If you have to tell your boss you're good with Excel, you're NOT!!
    All I know about Excel I owe to my ignorance!
    Scotch: Because you don't solve great Excel problems over white wine

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com