Problem with choosing value out of table. Please help

Hello Guys,

I'm in need of a huge favor.
It's been an hour that I'm searching for a solution and cannot find an answer.

So, the problem is;
I have a table and in the table there are different values in it.

I want to have a function in the excel which chooses desirable value out of the table and gives to me.



Please see the attached file.

Thanks so much if you are helping.
I wish you all success in your problems.

Hello joshgun and Welcome to Excel Forum.
I believe that the following is what you are looking for: =INDEX(H8:N18,MATCH(D7,G8:G18,0),MATCH(B7,H7:N7,0))
Note that you may need to change the commas to semicolons based on regional settings. If so that formula should read: =INDEX(H8:N18;MATCH(D7;G8:G18;0),MATCH(B7;H7:N7;0))
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have blessed day.