Cell Reference Issue

[Craig]

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:A19,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.

 

[Jacob Skaria]

USE INDIRECT()

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

 

[Craig]

Great, thanks.

--
Craig

USE INDIRECT()

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