|
|
|
|
|
|
|
|
|
|
| |
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
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
Change your calculation mode to automatic - Tools / Options / Calculation tab, click Automatic.
HTH,
Bernie
MS Excel MVP
"J. K. Parks" <J. K. Parks@discussions.microsoft.com> wrote in message
news:DBC17BD9-F530-4418-B08A-E5E3998665C6@microsoft.com...
> 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
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Thanks much...I took my Options for granted since I didn't make a change.
Are there any usual suspects which would have caused this change. As
indicated in my plea below, it was working fine up til now...
"Bernie Deitrick" wrote:
> Change your calculation mode to automatic - Tools / Options / Calculation tab, click Automatic.
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "J. K. Parks" <J. K. Parks@discussions.microsoft.com> wrote in message
> news:DBC17BD9-F530-4418-B08A-E5E3998665C6@microsoft.com...
> > 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
> >>
> >>
>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Excel takes the calculation mode of the first workbook opened during a
session and applies that mode to all subsequent workbooks opened in that
session.
i.e. ignores which calc mode the subsequent workbook had when saved.
Gord Dibben MS Excel MVP
On Wed, 17 Dec 2008 11:46:01 -0800, J. K. Parks <J. K.
Parks@discussions.microsoft.com> wrote:
>Thanks much...I took my Options for granted since I didn't make a change.
>Are there any usual suspects which would have caused this change. As
>indicated in my plea below, it was working fine up til now...
>
>"Bernie Deitrick" wrote:
>
>> Change your calculation mode to automatic - Tools / Options / Calculation tab, click Automatic.
>>
>> HTH,
>> Bernie
>> MS Excel MVP
>>
>>
>> "J. K. Parks" <J. K. Parks@discussions.microsoft.com> wrote in message
>> news:DBC17BD9-F530-4418-B08A-E5E3998665C6@microsoft.com...
>> > 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
>> >>
>> >>
>>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies