display the cell value in the next 33rd cell
 

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!

display the cell value in the next 33rd cell
 

"bmnjna2019" wrote in message
...
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...

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)
--
David Biddulph

display the cell value in the next 33rd cell
 

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.

--
Regards

Roger Govier


"bmnjna2019" wrote in message
...
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!

display the cell value in the next 33rd cell
 

thanks for your help!

"David Biddulph" wrote:

"bmnjna2019" wrote in message
...
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...

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)
--
David Biddulph

display the cell value in the next 33rd cell
 

thanks for your helps!

"Roger Govier" wrote:

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.

--
Regards

Roger Govier


"bmnjna2019" wrote in message
...
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!