display the cell value in the next 33rd cell

B

bmnjna2019

I need some help with writing a 'search & display' formula:

Scenario:
cell A9 has a value of $4600
-> set cell T2 to '=A9'

Question: what formula do I put in T3 if I want it to return the value in
cell A42 (basically, every 33rd cell from a range of cells). This is for a
monthly report where the starting cell is not always 'A9', and the locations
of the 'next 33rd cell' varies from month to month...

thanks!
 
D

David Biddulph

bmnjna2019 said:
I need some help with writing a 'search & display' formula:

Scenario:
cell A9 has a value of $4600
-> set cell T2 to '=A9'

Question: what formula do I put in T3 if I want it to return the value in
cell A42 (basically, every 33rd cell from a range of cells). This is for
a
monthly report where the starting cell is not always 'A9', and the
locations
of the 'next 33rd cell' varies from month to month...
Click to expand...

One way would be to put the address of your starting point (A9, for example)
in a cell such as T1, and then T2 could be =INDIRECT(T1), and T3 could be
=OFFSET(INDIRECT(T1),33,0)
 
R

Roger Govier

Hi

Take a look at the Offset function
=OFFSET(A9,33,0)
says take the value that is offset by 33 rows from A9, and 0 columns
from A9 hence A42

The 33 and 0 could be cell values as opposed to absolute numbers.
 
B

bmnjna2019

thanks for your help!

David Biddulph said:
One way would be to put the address of your starting point (A9, for example)
in a cell such as T1, and then T2 could be =INDIRECT(T1), and T3 could be
=OFFSET(INDIRECT(T1),33,0)
Click to expand...
 
B

bmnjna2019

thanks for your helps!

Roger Govier said:
Hi

Take a look at the Offset function
=OFFSET(A9,33,0)
says take the value that is offset by 33 rows from A9, and 0 columns
from A9 hence A42

The 33 and 0 could be cell values as opposed to absolute numbers.
Click to expand...
 
Top