Another way...

=SUMPRODUCT((A2:A7="Rose")*(B2:B7=15%)*(C1:F1=2)*C 2:F7)


"Frances C" wrote:

to beginu thanks for your help. I need a formula for the following
information. I have a table with the following information:
1 2 3 4
Rose 5% 101 102 103 104
Rose 10% 201 202 203 204
Rose 15% 301 302 303 304
Jack 3% 401 402 403 404
Jack 6% 501 502 503 504
Jack 9% 601 602 603 604

I need a formula that when I request "Rose @ 15% @ 2" My answer is 302

Hope you can understand, Thanks

Frances