I've attached a workbook illustrating my challenge. In one column I list sheet names. In another column, I have various dates.
I want to create a formula in a third column which takes (a) the sheet name & (b) an array expressed as $A$1:$M$300 and then performs a VLOOKUP function using (a) and (b) to define the array.
There are over 2,000 rows in the actual sheet I'm using, plus I've got over 75 worksheets (each with identical structure) with the data I need to pull up in the first sheet.
I've tried nesting INDIRECT within VLOOKUP, but I'm running into probs with the syntax.
I prefer not to use named ranges, as I believe I'd need to manually name 75 individual ranges.
Thanks for your help on this.
Bookmarks