It can. This worked fine for me from Sheet2

=OFFSET(Sheet3!A1,1,0)

What is your formula.

--
HTH

Bob Phillips

"AlistairJ" wrote in message
...
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