Cell Reference Issue

  • Thread starter Thread starter Craig
  • Start date Start date
C

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.
 
USE INDIRECT()

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