Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 2,801
- Office Version
- 365
- Platform
- Windows
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)
=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)