How do I make an absolute formula (not relative)?

I know about the difference between an absolute and relative REFERENCE... but I need to know if I can make a formula absolute.

Absolute ex: $A$5
Relative ex: A5

Absolute ex: $C$6
Relative ex: C6

So I have a formula:
=getPartNumber(A20, Z20)

and all the cells are physically changing positions except for the cell I put this formula. And all the function inputs are automatically being updated. If I would change cell A20 and move it to A21 then the formula would look like...
=getPartNumber(A21, Z20) and I don't want that.

I want to be able to change any cell location without updating formulas.

Is there a way to do this?

Note: =getPartNumber($A$20, $Z$20) does not work.

Please Login or Register  to view this content.

Is that what you are talking about? As in, always point to A20 even when cells are cut or inserted?

You could also do something like this and make it (slightly) less volatile.

Please Login or Register  to view this content.