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.

A technique for doing multiple lookups is described in:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu200842


"rawoessner" wrote:

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.

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


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gary''s Student" wrote:

A technique for doing multiple lookups is described in:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu200842


"rawoessner" wrote:

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.