Multiple Results

  • Thread starter Thread starter Michelle
  • Start date Start date
M

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
 
Michelle said:
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
Click to expand...

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
 
Back
Top