I don't seem to be having any luck trying to search for the solution I need so hoping for some help.
I have a spreadsheet I run that has various sheets which lookup data from a subset of columns from the source page.
When new data is received I insert a column at the start of this data which then shifts all my xlookup formulas across (following the original data that being looked up).
What im trying to do is not have this happen. So if my lookup formula is =XLOOKUP(A3,B:B,G:P) it will never change regardless of how many columns insert in-between Columns G and P.
I have a spreadsheet I run that has various sheets which lookup data from a subset of columns from the source page.
When new data is received I insert a column at the start of this data which then shifts all my xlookup formulas across (following the original data that being looked up).
What im trying to do is not have this happen. So if my lookup formula is =XLOOKUP(A3,B:B,G:P) it will never change regardless of how many columns insert in-between Columns G and P.