Try this.

Table in the range A2:F7

A10 = Rose
B10 = 15%
C10 = 2

=SUMPRODUCT(--(A2:A7=A10),--(B2:B7=B10),INDEX(C2:F7,,C10))

--
Biff
Microsoft Excel MVP


"Frances C" wrote in message
...
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