Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF positive values only from database | Excel Worksheet Functions | |||
HELP! Filtering and sorting lists. | Excel Worksheet Functions |