Hi,

For the example you gave:

=IF(Oct!AB24=MAX(Oct!AB24,Sep!AB24),"Oct!AB24","Se p!AB24")

Can't use most of Excel's functions across 3D.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RJW999" wrote:

I have a formula using a 3D range, =max(Oct:Sep!AB124). Is there anyway I can
return the address of the max value, which could be on any one of 12
worksheets? Formulae based on Address+Index don't work with a 3D range.