I have a formula to copy and it keeps changing.

=VLOOKUP(RIGHT(A6,2), Values!$A1:$B104,2,FALSE)

When I copy it down the page it brings back A6 updating
correctly but the $A1:$B104 changes and short of changing
999 entries I cant get it to paste special at all.

I have been pulling my hair out! Can anyone solve this
for me?

Pete