Who buys the apples

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.

Hi!

Assume the "Who" range is A2:A50 and the "What" range is B2:B50.

E2 = apples

Formula in F2:

=INDEX(A2:A50,MATCH(E2,B2:B50,0))

Biff

"Benj" <[email protected]> wrote in message
news:[email protected]...
> 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.

another way,=vlookup(e2,A2:B50,2,false).In cell e2 you can type or return
from a list the item you are looking for and the lookup wil tell you who
bought em
--
paul
remove nospam for email addy!



"Biff" wrote:

> Hi!
>
> Assume the "Who" range is A2:A50 and the "What" range is B2:B50.
>
> E2 = apples
>
> Formula in F2:
>
> =INDEX(A2:A50,MATCH(E2,B2:B50,0))
>
> Biff
>
> "Benj" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>