Offset question

C

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.
 
S

SteveG

Chris,

Try this instead,

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

HTH

Stev
 
Top