Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
Cell reference Issue | Excel Worksheet Functions | |||
Cell Reference issue | Excel Worksheet Functions | |||
Cell Reference Issue | Setting up and Configuration of Excel | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions |