Find cell value from Row & Column match

[nularry]

I am trying to create a formula to get a cell value that matches a specified item which is in the row, and specified item which is in the column title. Example below. Data is A1:E5. I am wanting a formula where the question marks are H2 to return a value of 8 (Banana row & 2021 column). Thank you for any help you can give.

	2020	2021	2022	2023			2021
Apple	5	7	3	2		Banana	???
Orange	2	6	2	8
Banana	9	8	5	2
Grape	6	5	9	5

 

[proficient]

Why use the volatile offset function when there is no need for it?

I was trying a different method. I have shared four more.