I have a spreadsheet which has

Column A - List of Products we sell
Column B - 2022 Prices
Column C - 2023 Prices
Column D - 2024 Prices

i want to create a spreadsheet where the user work out how much the total product costs.

In simple terms, if the User Selects 'Product A' and then '2022' - both drop down lists - then the result will be the price of the product in 2022, (answer from cell B2)

if the User Selects 'Product B ' and then '2023' - both drop down lists - then the result will be the price of the product B in 2023 , (answer will be in cell C3)

any ideas how I use VLoookup or similar in that way!