On sheet ABC I have a drop-down with Jan-May as options and depending on the selection, it places a number onto cell X1 (ie Jan=1, Feb=2, etc)
For each month, I have a sheet, labeled 1, 2, 3, etc.
What I want to do is display cell A1 from the respective sheets depending on the drop-down selection. For example, if Jan is selected, it should display '1'!A1, if Feb '2'!A1, etc
I somehow need to make the formula to utilize cell X1 on the ABC sheet, something like 'X1'!A1, but this doesn't work. I also attempted other similar formulas. (I'd like to avoid using if/then statements)
Any help would be greatly appreciated.
Bookmarks