Match, Find?

[Guest]

Hi,

On column A, there are numbers designated to names on col B.

Col A Col B Col C Col D
1 aaa bbb 2
2 bbb ddd 4
3 ccc ddd 4
4 ddd ccc 3

The names on Col C will apprear maybe repeatedly.

On col D, I'd like to have a formula that will indicate the designated
number of the names as indicated above.

Please help.

 

[Biff]

Hi!

Try this in column D:

=INDEX(A$1:A$4,MATCH(C1,B$1:B$4,0))

Copy down as needed.

Biff