I know you can lock a cell reference by using $ where needed (e.g. $D$6, M$7, and so on).
But what if you are using a table and want to lock a reference?
In the attached file, I show an example of referencing the first column in a table. As is often the case, I want to copy/drag that formula to other cells, but also want the reference to be static.
Since I'm using a table, thus using names in that table, they shift as I copy/drag the formula over.
If there's no way to lock a name like this, I'm guessing that the solution would be to simply type in the array reference?
Locking references.xlsx 13.35KB 122 downloads