DIFFICULT: Merging sets of data into one master column by using email as identifier?

[Rubbr_Dukkie]

Hey guys,

First off I'll start by saying I'm decent at best with excel.. So don't expect me to know a whole lot, so don't be afraid to get "laymans terms" with me.. I know what I'm good at, and excel is NOT it.


That being said:

I have a master list of email addresses with corresponding unique IDs.

I have a smaller list of email addresses without ID's. All I need to do is take the ID from the master list, and apply it to the smaller list (using the email address as a unique identifier)

so in essence, if I combined the two lists, a very simplified version of what needs to happen, would look like this: (red is the small list, green is the master list)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Id[/TD]
[TD]Email[/TD]
[TD]Information[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]a@a.com[/TD]
[TD]abc[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]b@b.com[/TD]
[TD]def[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]c@c.com[/TD]
[TD]xyz[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]a@a.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]b@b.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]c@c.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]d@d.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]e@e.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]f@f.com[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

and I would need to turn that into

[TABLE="width: 500"]
<tbody>[TR]
[TD]Id[/TD]
[TD]Email[/TD]
[TD]Information[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]a@a.com[/TD]
[TD]abc[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]b@b.com[/TD]
[TD]def[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]c@c.com[/TD]
[TD]xyz[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]d@d.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]e@e.com[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]f@f.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




If someone could show me how to do this, it would be MUCH appreciated. I would probably need a fairly decent walk-through. I'm young and work with computers everyday for my business, so I'm very tech savvy but I just don't know my way around excel or what it can / can't do.

I also use Mac and I've heard you cannot program Macros with that? Not sure how much truth there is to that but figured you guys might know better than me. I'm using Excel 2011.

Thanks Much!

 

[Rubbr_Dukkie]

bump