There is the result for your suggestions as shown below, but I would like to
select BOY for 1 and return in cell E1, APPLE for 2 and return in cell E2,
and APPLE for 3 and return in cell E3, there is missing the selection process
based on your formula, which is the tough part and I don't know how to do it.
Do you have any suggestions on how to do it in Excel?
Thank you very much for any suggestions
Eric

[A] [b] [C] [D]
1 APPLE 1 APPLE
1 BOY 1 BOY
2 APPLE 2 CAT
3 CAT 3 APPLE
1 CAT 1.000000001 CAT
2 CAT 2.000000001 CAT
3 APPLE 3.000000001 APPLE


"Max" wrote:

Did the earlier work out for you?
I don't understand your additional/new query below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Eric" wrote:
Thank you very much for suggestions
Could you please provide more detailed description on how to retrieve
BOY for 1,
APPLE for 2, and
APPLE for 3?