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