I want to copy a VLOOKUP formula down down the worksheet. When I use the drag
handle it increments 2 values ie A1, A2, A3 etc. I want it to increment one
of the values but i want the other to stay the same.

How do I do it?? Please help

Mart

A preceding $ indicates a part of the address to hold constant, as in
$A1, A$1, or $A$1 to hold the column, row, or both constant.

Jerry

Martc wrote:

I want to copy a VLOOKUP formula down down the worksheet. When I use the drag
handle it increments 2 values ie A1, A2, A3 etc. I want it to increment one
of the values but i want the other to stay the same.

How do I do it?? Please help

Mart

What if this doesn't work. It used to, but now when I drag, the copy cell
value is returned to all pasted cells, even though the search value should
return a different value. I can retype the cell from scratch and it works,
but no matter which copy technique I use, the initial cell's return value is
defaulted to all pasted cells.


"Jerry W. Lewis" wrote:

A preceding $ indicates a part of the address to hold constant, as in
$A1, A$1, or $A$1 to hold the column, row, or both constant.

Jerry

Martc wrote:

I want to copy a VLOOKUP formula down down the worksheet. When I use the drag
handle it increments 2 values ie A1, A2, A3 etc. I want it to increment one
of the values but i want the other to stay the same.

How do I do it?? Please help

Mart

Change your calculation mode to automatic - Tools / Options / Calculation tab, click Automatic.

HTH,
Bernie
MS Excel MVP


"J. K. Parks" <J. K. wrote in message
...
What if this doesn't work. It used to, but now when I drag, the copy cell
value is returned to all pasted cells, even though the search value should
return a different value. I can retype the cell from scratch and it works,
but no matter which copy technique I use, the initial cell's return value is
defaulted to all pasted cells.


"Jerry W. Lewis" wrote:

A preceding $ indicates a part of the address to hold constant, as in
$A1, A$1, or $A$1 to hold the column, row, or both constant.

Jerry

Martc wrote:

I want to copy a VLOOKUP formula down down the worksheet. When I use the drag
handle it increments 2 values ie A1, A2, A3 etc. I want it to increment one
of the values but i want the other to stay the same.

How do I do it?? Please help

Mart