Offset question

[Chris]

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.

[David Billigmeier]

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.

[SteveG]

Chris,

Try this instead,

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

HTH

Steve