My advice is - redesign your data table. E.g. your price table will be like;
Column A - Product;
Column B - Year;
Column C - Price.

If you want to use Data Validation Lists to select product or year (either in your prices table, or in your report sheet), you also need according worksheets with products list and years list. Whenever a price for new product or year must be registered, this product or year must be registered in those tables at first. After that, the user can add new price to prices table. The additional bonus - users can't enter products or years with typos.

On your report sheet, you'll have data validation lists to select product and year, and the wanted price is calculated like as (I use Defined Table syntax in my example,you can replace Defined Table column references with standard range references wen you want. And in my example I defined cells with Data Validation Lists as Defined Names RepProduct and RepYear):
Also, when you define your prices table as Defined Table (e.g. PriceTable), or you apply manually the Autofilter to your table, the asked task isn't really needed at all - user can set autofilter for Product and Year columns, and gets it. Even more - with autofilter user can select e.g. several products, and a year, and gets a list of prices for those products!