Match, Find?
Hi!
Try this in column D:
=INDEX(A$1:A$4,MATCH(C1,B$1:B$4,0))
Copy down as needed.
Biff
"Danny" wrote in message
...
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.
|