cell reference plus "x" number of cells down or across

[michael c]

Hi. I have three very related questions:

1. I have a cell, say A1 on Sheet 1, and I'm trying to
create a function on sheet 9 that will tell me what is in
the cell that is 10 ROWS below A1.

2. I have a cell, say A1 on Sheet 1, and I'm trying to
create a function on sheet 9 that will tell me what is in
the cell that is 10 COLUMNS to the right of A1.

Any suggestions would be a tremendous help! Thanks!

 

[michael c]

Thanks to both of you! This will be a huge help. I'll give
it a try.

 

[James]

Hello from SA

I know the answer,

Use the function:
=Sheet9!A2
Where "sheet9!" will be the tab of the source data
and A2 the cell within the specified sheet.

Also use relative and absolute references, R1C1 format,
but you must switch on the R1C1 mode from your
TOOLS>OPTIONS>GEN TAB

To specify a cell say 2 cells directly above(same column):
=R[-2]C

To specify a cell say 3 columns to left (Same Row):
=RC[-3}

Good Luck


See "referance" under the help guide
See "Relative vs. absolute references"

=Sheet3!A2