Index, match with 2 values

[Vctr]

Hi,

Im wondering if its possible the lookup a values after matching with 2 other values.
Here is the situation:
I want to select a name (dropdown menu), type in the product id and then get the right price related to those.
This is the formula i tried to use: =INDEX(C3:C7;MATCH(B12;B3:B7;MATCH(A12;A3:A7)

For the name John, the formula works, but not for the name Peter.
Where does it go wrong?

Tia

 

[theozz]

maybe this wanted
formula is
=INDEX(C3:C7,MATCH(1,(B3:B7=B12)*(A3:A7=A12),0))
and Ctl+Shft+Enter
sould get answer

 

[theozz]

maybe this wanted
formula is
=INDEX(C3:C7,MATCH(1,(B3:B7=B12)*(A3:A7=A12),0))
and Ctl+Shft+Enter
sould get answer

 

[njimack]

=SUMPRODUCT(--(A3:A7=A12),--(B3:B7=B12),(C3:C7))

 

[Vctr]

Thx both of you!!
Both formulas work :D

 

[Peter_SSs]

Another slight variation would be:
=INDEX(C3:C7,MATCH(A12&B12,A3:A7&B3:B7,0))
confirmed with Ctrl+Shift+Enter