I'm trying to create a document in which cells reference another cell in a microsoft query table, e.g. in cell A60 the formula is =M6972. However, when I update the query the value in A60 will change to reflect data additions/reductions in the query table. I want the cell to continue to show the same value regardless of where the reference cell moves in the query table.
Solved by T. H. in 26 mins