Cell reference within a cell reference

[nigelbloomy]

I have the formula =Min('Sheet1'!A2:A4). I need to be able to put a formula in for the "2" and the "4". I have a match formula that gives me the numbers I need. I would like to put that match formula inside this min formula to tell it which rows to look at. I've tried using indirect but I can't get the syntax right.

As the thread title states I could also just reference the cell that has the match formula in it. This is the closest I have gotten so far, but I get a name error: =MIN('Sheet1'!I&E2&":I"&I2)

[ChemistB]

If there are no spaces in your sheet names

=MIN(INDIRECT("Sheet1!I" & E2&":I"&I2))
If you are substituting in a sheet name with spaces for sheet1, then you need to put single quotes inside the double quotes

=MIN(INDIRECT("'This Sheet!'I" & E2&":I"&I2))

[nigelbloomy]

That's exactly what I was looking for. Those single and double quotes get me every time. Thank you!