I am trying to create an XLOOKUP formula that returns a value based on the date. The data table I am working with has the last 12 rows in the table as forecasted sales which starts with the current month and gives forecasted sales for the next 11 months. What I want to do is have a dropdown menu of months that will allow the user to pick what month the XLOOKUP function will look for. For example, if I choose June the formula will return the relative value in the column with header 2022-06-01 on the table.

I am open to any suggestions on how to generate this. Many thanks in advance.