I need help. I want to drag the following formula down a column and change the last column reference as I drag it down the column. Can some one help me write a formula so the last column reference advances one column to the right as I drag it down the column I am copying the info please? Here is the formula I am writing and here is how I want it to advance. I highlighted the desired changes in red.

I'm a novice when it comes to formulas, so take it easy on me.

=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,('Volume Budget'!A:A))

=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,('Volume Budget'!B:B))


=AVERAGEIF('Volume Budget'!A:A,'Margin Projections'!$A$1,('Volume Budget'!C:C))


And so on.....

Thank you for your help.