title: Dynamic INDIRECT formula with range
body: <p>I have some dynamic input, in my case, the name of the month in cell I25. Based on the month the function in cell H32 should reference a sheet with the name of the month and cell A18 within that sheet. Now this I can handle and have made it possible through the INDIRECT function.</p>
  
  <p>The issue I'm having is with dynamic range. For example, I would like cell H33 to reference cell A19 within the worksheet "February". The closest I got to it was <code>=INDIRECT($I$25"&amp;"!A18:A200")</code>. And it seems to be working, but for some strange reason it starts referencing the cells contents from A36 onwards, which I don't get. Suggestions?</p>
  
  <p>Any help would be greatly appreciated.</p>