View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bmnjna2019 bmnjna2019 is offline
external usenet poster
 
Posts: 5
Default 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!