Hello All!

I am trying to enhance my index match formula that I am currently using. I created a few "databases" of numbers, using named ranges created by a dynamic offset formula: (DB2018, DB2019). I have tried using an Indirect function but it doesn't seem to work since I'm not referencing a worksheet or cell. I would like this to work so that if my date in column A is 12/2018, the formula would know to use the range "DB2018".

Is something like this possible?

Thanks in advance!