Lookup 2 values and return results based on these

I am having problems working out what formula to use.

I am wanting to calculate the cost (Column M) based on the season and the type of vehicle, so it looks up the Cat of the car in the job details section and looks up the level in the customer receipt section and then calculates the price based on the details in the info table.



Breakdown3.jpg

Hello and good eve

Please attach a sample file to help you better

Regards
Jaya

Thank you, hopefully this may make it clearer

How about:

=INDEX($A$4:$D$7,MATCH($G$11,$A$4:$A$7,0),MATCH(K8,$A$3:$D$3,0))

See if this works for you

=SUMPRODUCT((G11=$A$4:$A$7)*(K8=$B$3:$D$3)*($B$4:$D$7))

Regards
Jaya