The first offset parameter is supposed to be a cell reference for example $A$16

For my particular purpose my cell reference will always be changing with
different worksheets so I would like to replace the 16 with
MATCH("Run",A:A,0).

The function MATCH("Run",A:A,0) does indeed return a valid number, so
howcome I can't simply replace 16 with MATCH("Run",A:A,0)? They're both
numbers but excel isn't letting me do it.

Try:

=OFFSET(INDIRECT("A"&MATCH("Run",A:A,0)),....)


--
Regards,
Dave


"Chris" wrote:

The first offset parameter is supposed to be a cell reference for example $A$16

For my particular purpose my cell reference will always be changing with
different worksheets so I would like to replace the 16 with
MATCH("Run",A:A,0).

The function MATCH("Run",A:A,0) does indeed return a valid number, so
howcome I can't simply replace 16 with MATCH("Run",A:A,0)? They're both
numbers but excel isn't letting me do it.

Chris,

Try this instead,

=OFFSET(INDIRECT("$A$"&MATCH("Run",A:A,0)),0,1)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=570092