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.