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)

Id	Email	Information
	a@a.com	abc
	b@b.com	def
	c@c.com	xyz
12	a@a.com
14	b@b.com
16	c@c.com
18	d@d.com
20	e@e.com
22	f@f.com

<tbody>
</tbody>

and I would need to turn that into

Id	Email	Information
12	a@a.com	abc
14	b@b.com	def
16	c@c.com	xyz
18	d@d.com
20	e@e.com
22	f@f.com

<tbody>
</tbody>

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