Add to a formula to direct it to a column name without using a table

[Myopic Matt]

Hi,

Any help is greatly appreciated.
Is there a way without using an excel table that I can reference a column name within a formula instead of the column letter so changes to the location of that column doesnt break the entire formula(s).
Reason I ask is that Im jointly working on a spreadsheet whose columns are being changed often by the other person which is breaking my formula.
Example below wherein column "W" is equal to "Committed" name of the column. I'd like to set it so $W$W column is instead pointed to the name of the column within this tab. Thank you.
Help:
=AVERAGEIFS(Opps.Aging!$W:$W,Opps.Aging!$E:$E,'Stage Age'!N$7,Opps.Aging!$Y:$Y,'Stage Age'!$L$8,Opps.Aging!$M:$M,">="&$M$6)

Thank you!
Matt

 

[Fluff]

You can use named ranges Named Ranges in Excel | Exceljet