Golf Gal,

You can use a formula like

=SUMPRODUCT((D2:D10="Pants")*(A2:A10=days)*(B2:B10 =discount)*(C2:C10))

but that would require that there be only one netry of pants for x days at y
discount. In your example table, you have 3 entries for pants at 30 days at
a 5% discount, which would cause this to return the sum of all three of
those prices.

HTH,
Bernie
MS Excel MVP


"GolfGal" wrote in message
...
From reading here, it appears that Index & Match are the function I need,
but
I can't seem to get it to do what I need.

Let's say I receive a price list from a wholesaler each morning (cannot be
sorted). The same products may not necessarily be in the same rows each
day,
depending on availability. Simple example:

DAYS Disc PRICE PRODUCT
30 5% 19.99 Pants
60 10% 24.99 Shirt
90 20% 64.99 Dress
30 5% 32.99 Pants
60 10% 18.99 Shirt
90 20% 84.99 Dress
30 5% 29.99 Pants
60 10% 9.99 Shirt
90 20% 29.99 Dress

Here is what I'd like the function to do:

Find single product, e.g. pants in column d
Find only pants that I can buy at that price for 60 days (colA) This
would refer to another cell on my worksheet named "days"
From that list of pants that I can buy at that price for a certain number
of
days, Find only pants that offer a certain discount , e.g. 20%
This would also refer to another cell on my worksheet named "discount"
Finally, the result of the formula needs to be the price of these pants
that
I can buy for 60 days at a 20% discount.

Is it possible for an excel function/formula to do this?

Thanks