Compare EE #s & Copy Info

[Steve C]

I'm for a formula that will compare 2 columns and copy an adjacent column if
they match. In the example below, I would compare the EE#s in columns B and
c and if they match, it would copy the name in column A to column D.

A B C D
Name EE# EE# Desired Result
Tom 24 11 Tony
Bill 36 24 Tom
Tony 11 36 Bill

 

[RagDyer]

Try this in D2:

=INDEX($A$2:$A$50,MATCH(C2,$B$2:$B$50,0))

 

[Steve C]

Perfect. Thanks.

Try this in D2:

=INDEX($A$2:$A$50,MATCH(C2,$B$2:$B$50,0))

 

[RagDyeR]

You're welcome, and thanks for the feed-back.