Sheet Formula

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.

You could use the INDIRECT funtion...

Please Login or Register  to view this content.

Bingo, thanks!!