Change VLOOKUP Table Array in Column Based on Dropdown

In the attached workbook, in the "Expenditures 23-24" worksheet, columns M and N have dropdowns in row 2 that allow the user to select a fiscal year, which corresponds with the data in the worksheets for those two previous years.

The source for the dropdown list is a named range. It can be found in the Data worksheet in cells P6 through Q9. Column Q lists the name of the table that corresponds to each fiscal year. The catch is that this list will expand, so in the future, when there is a worksheet for fiscal year 2024-2025, the dropdown will show that option because I'll add data to P10 and Q10, and the VLOOKUP reference will have to change to the name of the new fiscal year table, found in Q10.

I need a way for the user to choose which fiscal year they want to compare in columns M and N. Is there a way to change the table array reference dynamically in all of the rows for that column in the table? Note that the table may get larger or smaller based on the data that is imported. This is only a small subset of data.

Any help with this is much appreciated!

I was able to use some code that a forum member helpfully worked up for me with in a similar situation:

Please Login or Register  to view this content.

The thing is that I had to make this handle more rows than is necessary. My current full dataset has about 2600 rows, so I have it looking in 3000 rows. However, this seems to affect performance, as it takes a few seconds to work, and ideally, I would like to have a script that only checks in the table column, regardless of how many rows there are.

Thank you so much John! That worked extremely well and the IFERROR is recognizing the 0 value as a monetary value now as well, which I was having trouble with before. I really appreciate your help with this!