Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula keeps changing
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the range for averages with out changing the formula. | Excel Worksheet Functions | |||
Help with changing a formula | Excel Worksheet Functions | |||
changing formula | Excel Worksheet Functions | |||
how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
Copy Formula Down Without Changing Entire Formula | Excel Discussion (Misc queries) |