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.