Hi all again!

here is the deal, I have one column to enter say WHO BUYS so say A2
contains Mike, next column WHAT DOES HE BUY say B2 contains apples, A3=
Orange, B3 = John.
At the end I want to know who bought the apples and who the orange say I
take E2 contains apples then I want F2 to tell me Mike and so on.

Thank you all so much for sharing your knowledge,
All the best

Thanx for you David O & David McRitchie for answering my previous questions.