Find value based on three criterias

I have tried to find the correct solution both here in the forum and on various sites, but I canīt wrap my head around how to solve this.
Attached you find an easy example of what Iīm trying to achieve, but in reality the file is of course much larger.

• In column A I have the first criteria, in this example a fruit.
• On row 1 is the second criteria, in this example Cost price
• On row 2 is the third criteria, in this example month

So how would a formula look that answers the question “What was the Cost price of Pears in March” based on the values in A8:A10?

I have experimented both with an array INDEX/MATCH and a VLOOKUP with multiple MATCH, but canīt get it to work.

Very thankful for all input, thank you!

Try this:

=SUMPRODUCT(($B$1:$K$1=A8)*($B$2:$K$2=A9)*($A$3:$A$5=A10),$B$3:$K$5)

Hi Busk,

Use this formula, hope this will solve your purpose

=INDEX($A$1:$K$5,MATCH($A$17,$A$1:$A$5,0),MATCH(A15&A16,A1:K1&A2:K2,0))

Busk:

1. Do NOT post-edit your posts removing information that may be useful to someone else with a similar issue later. I have reinstated your opening post - leave it alone, please.
2. I have just seen your rep - thank you.

Sorry - I have already amended my post. It looked as if you were responding to Nisha, and had ignored my suggestion. I realise now this was not the case. However, the reverse is true: you should thank ALL respondents to your thread, so Nisha is due some credit, too. Reputation points are nice, but saying 'thank you' in your thread matters more, in my view.