Results 1 to 3 of 3

Thread: Combining A-B and B-C colums from two different worksheets to A-B-C in one worksheet

  1. #1

    Combining A-B and B-C colums from two different worksheets to A-B-C in one worksheet

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I would be very greatful if someone could help me with the following issue:
    Basically, I've got two seperate excel sheets. One contains a list of employee codes(containing letters and numbers) and information related to each employee in the other columns, like this:

    employee no | data
    1A xy
    1A cd
    1A jn
    2B fg
    2B hi

    ... and so forth. Another excel sheet contains (among other columns with other data), the same employee no and the employee name, like so:

    employee no | name
    1A John Doe
    2B Peter Jackson
    3B George Lucas

    What I need is some kind of manipulation in Excel that will allow me to easily connect the two, so that I get something like this:

    employee no | name | data
    1A John Doe xy
    1A John Doe cd
    1A John Doe jn
    2B Peter Jackson fg
    2B Peter Jackson hi

    ... et cetera.

    Is it possible to largely automate this? It would really save quite a bit of time for me and my collaeges! I will email you a picture of a bottle of champagne as thanks :P


  2. #2
    Acolyte maninweb's Avatar
    Join Date
    Mar 2011
    Excel Version
    2010, 2016, 2016 Insider
    Hi Catpriest...

    IMHO the VLOOKUP() Excel function may help you concerning this problem.
    I have attached a file, in Sheet "Result", there is a sample how to retrieve
    the employees' data from its sheet. Hope it helps :-)

    Best regards :-)
    Attached Files Attached Files

  3. #3

    Thanks, it took some more tinkering, but the VLOOKUP function did the trick! Thanks!

Posting Permissions

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