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!
Bookmarks