Name match in column A to column C then copy email in adjacent column B next to matched name in column D

[sheenabest]

Need help with two lists of names and emails.

I have sample date below in which the names in column A are different to those in column C and need to;

1. See if the names in column C are in Column A
2. If the name is found in column A, copy the email address adjacent to it into Column D adjacent to the corresponding name in Column C?

Hope this makes sense

Thanks
Sheena

Column A	Column B	Column C
joe bloggs</SPAN>	joebloggs@me.com</SPAN>	anna smith</SPAN>
angus boreham </SPAN>	angusboreham@me.com</SPAN>	robert breen</SPAN>
rebecca quinn</SPAN>	rebeccaquinn@me.com</SPAN>	alex reed</SPAN>
anna smith</SPAN>	annasmith@me.com</SPAN>	joe bloggs</SPAN>
robert breen</SPAN>	robertbreen@me.com</SPAN>	sarah tooze</SPAN>
sarah tooze</SPAN>	sarahtooze@me.com</SPAN>	john wright</SPAN>
ken barber</SPAN>	kenbarber@me.com</SPAN>	Eileen morrow</SPAN>
greg shand</SPAN>	gregshand@me.com</SPAN>	ken barber</SPAN>
john wright</SPAN>	johnwright@me.com</SPAN>	julie prince</SPAN>
christopher makay</SPAN>	christophermakay@me.com</SPAN>	maria pine </SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>

 

[jim may]

Do you mean something like so?

Excel 2010
	A	B	C	D
1	joe bloggs	joebloggs@me.com	anna smith	annasmith@me.com
2	angus boreham	angusboreham@me.com	robert breen	robertbreen@me.com
3	rebecca quinn	rebeccaquinn@me.com	alex reed
4	anna smith	annasmith@me.com	joe bloggs	joebloggs@me.com
5	robert breen	robertbreen@me.com	sarah tooze	sarahtooze@me.com
6	sarah tooze	sarahtooze@me.com	john wright	johnwright@me.com
7	ken barber	kenbarber@me.com	Eileen morrow
8	greg shand	gregshand@me.com	ken barber	kenbarber@me.com
9	john wright	johnwright@me.com	julie prince
10	christopher makay	christophermakay@me.com	maria pine
Sheet1

Cell Formulas
Range	Formula
D1	=IFERROR(INDEX($B$1:$B$10,MATCH(C1,$A$1:$A$10,0)),"")

 

[sheenabest]

That hasn't worked, all the cells come up blank when I drag the formula down.

If it make a difference there are 2608 rows for columns A and B and only 1338 in Column C? I just used the above as sample data.

Thanks for your help.

Sheena

 

[jim may]

All I can Add is to change formula in Cell D1 to:

=IFERROR(INDEX($B$1:$B$2608,MATCH(C1,$A$1:$A$2608,0)),"")

And drag down to D1338.

 

[sheenabest]

Is there anyway you could attach an example please? I'm still not getting the email addresses to copy in the adjacent cell once matched?

Thanks

 

[jim may]

Select the Cell D1, then (assuming you are XL 2007 or later) on the Ribbon, go to Formulas, Formulas Auditing Group, then click on Evaluate Formula. It will step you through the components of the total formula showing you as you go, each calculation. Report back when any component doesn't seem to be producing what it should. Jim