How to find a value based on 2 criteria that are in the same other column

[smetu]

Sorry, I don't even know how enunciate my problem and that's why I cannot find any solution for it on the Internet.
So I've created a very simple table to give you a very simplified example of what I need to do and I will translate it to my real excel file.

Basically without changing anything in the table - because my real data in my real excel file are fixed, I need to be able to write a formula in the green cell to find the price of the Pink Shoes.
If someone can help me, it would save me!

Thank you to anyone who will accept the challenge!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

How about

=SUMPRODUCT((B2:D4=D8)*(B1:D1=C8),A2:C4)

 

[smetu]

Thank youuuuuu thank you thank you!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[smetu]

You're welcome & thanks for the feedback.

I have another one if I may.
Is there a way to find a formula again in the green box based on the grey and yellow boxes.
The fact that the transaction ID's of Fund I and Fund II are not in the same columns prevents me to find a solution to this problem.....

 

[Fluff]

As you have started a new thread for this question, you need to stick to it. Thanks