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

Catpriest

New member
Joined
May 6, 2011
Messages
3
Reaction score
0
Points
0
Hi,

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

Cheers,
Oliver
 

maninweb

New member
Joined
Mar 22, 2011
Messages
88
Reaction score
0
Points
0
Location
Germany
Website
excel-translator.de
Excel Version(s)
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 :)
 

Attachments

  • Catpriest.xls
    14 KB · Views: 45

Catpriest

New member
Joined
May 6, 2011
Messages
3
Reaction score
0
Points
0
Hi,

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