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!

"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

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!

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

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!