Formula to sheet change

[Sgwapt]

Is there a way To write an Offset formula that changes the sheet name when
indexed on a cell?

Ex: =OFFSET(A1!A2,A3,1)

Where: A1 = sheet name cell value the offset refers to, A2 = start cell, A3
= row to offset.

When I use "Sheet1!" in cell A1 it opens the File Not Found dialog.

--
George G

[Dave Peterson]

First, drop the ! from A1. You included it in your formula.

=OFFSET(INDIRECT("'" & A1 & "'!" & A2),A3,1)

The apostrophes maybe required for some sheet names (with spaces, for instance).



Sgwapt wrote:
>
> Is there a way To write an Offset formula that changes the sheet name when
> indexed on a cell?
>
> Ex: =OFFSET(A1!A2,A3,1)
>
> Where: A1 = sheet name cell value the offset refers to, A2 = start cell, A3
> = row to offset.
>
> When I use "Sheet1!" in cell A1 it opens the File Not Found dialog.
>
> --
> George G

--

Dave Peterson