Index-Match Formula Promblem

[rawoessner]

Hi,

Im working on a index-match formula for data with the same criteria but with
different values. When I try to use is it gives me the first value that it
finds. Is there a way for it to use only one value and then find the next
one?

Ex:
Date Name Price Company
1/1 Joe 5.35 Cannon
1/1 Joe 5.35 Lucent
1/2 Ian 6.35 Scotch

I have two sets of data, im compaing the date, name, and price and I need
the company data on the other sheet. When I input the index-match formula
for the transactions, I get "Cannon" for both lines and not Cannon and
Lucent. Is there a way for it to just use one value and then pull the next
with the same critera?

Thanks for the help.

 

[Gary''s Student]

A technique for doing multiple lookups is described in:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

 

[ryguy7272]

This is a great resource for Index/Match
http://www.contextures.com/xlFunctions03.html
http://www.contextures.com/xlFunctions03.html#IndexMatch