Can the offset worksheet function reference another worksheet

I have a workbook with a number of worksheets. Worksheet 1 contains the base
data. Worksheet 2 contains single rows of filtered data from 1, which is
updated from time to time with a simple macro. One cell of that filtered data
actually requires the data in the row below the the filtered data. I think
the offset function is the optimal means of extracting the contents of the
required cell by referencing a vlookup within the offset function, but having
no sucess - is it because the offset function doesn't work across different
worksheets? Any other ideas to address this issue will be welcome

It can. This worked fine for me from Sheet2

=OFFSET(Sheet3!A1,1,0)

What is your formula.

--
HTH

Bob Phillips

"AlistairJ" <[email protected]> wrote in message
news:[email protected]...
> I have a workbook with a number of worksheets. Worksheet 1 contains the
base
> data. Worksheet 2 contains single rows of filtered data from 1, which is
> updated from time to time with a simple macro. One cell of that filtered
data
> actually requires the data in the row below the the filtered data. I think
> the offset function is the optimal means of extracting the contents of the
> required cell by referencing a vlookup within the offset function, but
having
> no sucess - is it because the offset function doesn't work across
different
> worksheets? Any other ideas to address this issue will be welcome

Thanks for your interest Bob. My formula obviously has another flaw. It reads
=offset(vlookup(b22,Sheet1!A$6$:A$1400$,1,FALSE),1,7).
The formula is in C22 of sheet 2 and the required data is offset by 1 row
and 7 columns on sheet 1.

"Bob Phillips" wrote:

> It can. This worked fine for me from Sheet2
>
> =OFFSET(Sheet3!A1,1,0)
>
> What is your formula.
>
> --
> HTH
>
> Bob Phillips
>
> "AlistairJ" <[email protected]> wrote in message
> news:[email protected]...
> > I have a workbook with a number of worksheets. Worksheet 1 contains the
> base
> > data. Worksheet 2 contains single rows of filtered data from 1, which is
> > updated from time to time with a simple macro. One cell of that filtered
> data
> > actually requires the data in the row below the the filtered data. I think
> > the offset function is the optimal means of extracting the contents of the
> > required cell by referencing a vlookup within the offset function, but
> having
> > no sucess - is it because the offset function doesn't work across
> different
> > worksheets? Any other ideas to address this issue will be welcome
>
>
>