Can the offset worksheet function reference another worksheet

[Guest]

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

 

[Bob Phillips]

It can. This worked fine for me from Sheet2

=OFFSET(Sheet3!A1,1,0)

What is your formula.

 

[Guest]

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.