Lock Excel Table Column Easily

[Jeffrey Mahoney]

Is there an easy way while editing a formula with a Table column reference to lock it? Similar to pressing F4 to lock the column or row reference?

=IF(I$11="A",XLOOKUP($C15,SAPDataTbl[[PID]:[PID]],SAPDataTbl[April],0,0)/1000000,XLOOKUP($C15,Master_Data_Table[[ID]:[ID]],Master_Data_Table[Apr-23],0,0)/1000)

 

[Fluff]

Fraid not.

 

[Jeffrey Mahoney]

Thought so. Needed to hear it from somebody else.