Multiple Results

[Michelle]

Hi there Gang,

I have column A with many names & column B with many
numbers, I want to be able to extract a name from column A
& return the result from column B, not a problem, however
what if that name appears more than once in column A, say
it shows 3 times, how can I show the result from column B
3 times???, thanks Mx

 

[Paul]

Hi there Gang,

I have column A with many names & column B with many
numbers, I want to be able to extract a name from column A
& return the result from column B, not a problem, however
what if that name appears more than once in column A, say
it shows 3 times, how can I show the result from column B
3 times???, thanks Mx

You must understand that to get 3 results you will need 3 separate formulas.
How you can construct such formulas is described here under "Arbitrary
Lookups":
http://www.cpearson.com/excel/lookups.htm