N
NickCory
Hi,
I want to perform operations on address ranges, such as
MAXA(Value1:Value2), in which the range addresses themselves are
variables, the results of other operations.
There is no problem returning the range addresses using functions such
as CELL or ADDRESS(...) but the returned values don't seem to want to
plug into the next function.
For example, I use the formula
=ADDRESS(VLOOKUP(Pos_MinRear;Synopsis!$D$103:$G$108;4);3;;;"Synopsis!")
to return the string
'Synopsis!'$C$103
and a similar formula to return
'Synopsis!'$C$105
from which range I want to then find
MAXA('Synopsis!'$C$103:'Synopsis!'$C$105)
I'm sure there is a simple solution I have overlooked. Who can give me
a leg up with this?
regards
NC
I want to perform operations on address ranges, such as
MAXA(Value1:Value2), in which the range addresses themselves are
variables, the results of other operations.
There is no problem returning the range addresses using functions such
as CELL or ADDRESS(...) but the returned values don't seem to want to
plug into the next function.
For example, I use the formula
=ADDRESS(VLOOKUP(Pos_MinRear;Synopsis!$D$103:$G$108;4);3;;;"Synopsis!")
to return the string
'Synopsis!'$C$103
and a similar formula to return
'Synopsis!'$C$105
from which range I want to then find
MAXA('Synopsis!'$C$103:'Synopsis!'$C$105)
I'm sure there is a simple solution I have overlooked. Who can give me
a leg up with this?
regards
NC