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

  • Thread starter Thread starter michael c
  • Start date Start date
M

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!
 
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
 
Back
Top