There may be simpler formulas but try this:

Assuming that your original data is in the range A2:B6 and your
matching names are in cells C2:C6. In cell D2 enter this formula:

=IF(ISERROR(INDEX(A$2:B$6,MATCH(C2,A$2:A$6,0),2)), "",INDEX(A$2:B$6,MATCH(C2,A$2:A$6,0),2))

Then copy the formula down through cell D6.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=474127