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

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