Cell Reference Issue
 

I'm using Excel 2003.

The following formula works fine (returns the reference $E$14):

=CELL("address",INDEX(A8:N19,MATCH(A3,A8:A19,FALSE ),MATCH(B3,A8:N8,FALSE)))


However, the following formula DOESN'T work:

=offset(CELL("address",INDEX(A8:N19,MATCH(A3,A8:A1 9,FALSE),MATCH(B3,A8:N8,FALSE))),2,2)

I just want to return the value that's 2 rows down and 2 rows over from the
reference returned ($E$14).

Am I missing something?

Thanks.

--
Craig

Cell Reference Issue
 

USE INDIRECT()

=INDIRECT(CELL("address",INDEX(A8:N19,MATCH(A3,A8: A19,FALSE)+2,MATCH(B3,A8:N8,FALSE)+2)))
--
If this post helps click Yes
---------------
Jacob Skaria


"Craig" wrote:

I'm using Excel 2003.

The following formula works fine (returns the reference $E$14):

=CELL("address",INDEX(A8:N19,MATCH(A3,A8:A19,FALSE ),MATCH(B3,A8:N8,FALSE)))


However, the following formula DOESN'T work:

=offset(CELL("address",INDEX(A8:N19,MATCH(A3,A8:A1 9,FALSE),MATCH(B3,A8:N8,FALSE))),2,2)

I just want to return the value that's 2 rows down and 2 rows over from the
reference returned ($E$14).

Am I missing something?

Thanks.

--
Craig

Cell Reference Issue
 

Great, thanks.

--
Craig


"Jacob Skaria" wrote:

USE INDIRECT()

=INDIRECT(CELL("address",INDEX(A8:N19,MATCH(A3,A8: A19,FALSE)+2,MATCH(B3,A8:N8,FALSE)+2)))
--
If this post helps click Yes
---------------
Jacob Skaria


"Craig" wrote:

I'm using Excel 2003.

The following formula works fine (returns the reference $E$14):

=CELL("address",INDEX(A8:N19,MATCH(A3,A8:A19,FALSE ),MATCH(B3,A8:N8,FALSE)))


However, the following formula DOESN'T work:

=offset(CELL("address",INDEX(A8:N19,MATCH(A3,A8:A1 9,FALSE),MATCH(B3,A8:N8,FALSE))),2,2)

I just want to return the value that's 2 rows down and 2 rows over from the
reference returned ($E$14).

Am I missing something?

Thanks.

--
Craig