Thread: Variable Cell Reference?

Hi! I have what I hope is a simple problem.

I've run into an instance where I need a cell to be referenced based on the month. For example,
in July, the cell would be 'Sheet2'!AC7
In October, the cell would be 'Sheet2'!AC10
etc.

Is this possible with something along the lines of
'Sheet2'!AC...MONTH(TODAY())
or
Cell("Contents",'Sheet2'!AC...MONTH(TODAY()))

Thanks in advance

Could your provide a little more detail about what you are attempting to do this. There are multiple ways to reference an array and yield results based on that reference, but it depends on what the purpose of your worksheet is. Maybe an example sheet would help.