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" 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