Is it possible to have a formula, that references a table in another worksheet, increment the column by dragging down? The formula is =MIN(SFLD_Stats!B$3:B$26), and I need to drag it down multiple cells so that it increments to =MIN(SFLD_Stats!C$3:C$26), and so forth. The row range is always 3:26, the column is the only thing that changes. I know that if I drag a formula down, the rows will update and if I drag across, the columns will update, but I need the opposite. I saw a way to use INDEX to do a swap like this for data points, but I don't know how to use it with a formula.

Any help would be greatly appreciated.

Thanks,

Jeff