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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula keeps changing
Pete
Add some more $ signs in first formula then re-copy down the column. =VLOOKUP(RIGHT(A6,2), Values!$A$1:$B$104,2,FALSE) Another method is the give your table a defined name like MyList Select A1:B104 and InsertNameDefine Use the name instead of cell references in your formula. Gord Dibben Excel MVP On Sat, 15 May 2004 11:45:35 -0700, "Pete Primmer" wrote: 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 |
Reply |
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) |