selective autofill with functions

[vicvega]

I was working with a vlookup formula that I need to autofill down and have
only one area of the function change, I have checked some past posts on
autofilling and not found an answer,, I have also tried filling in a couple
and using them as examples for autofill but has not worked,,,

the desired results on the progressive cells would be:

=((VLOOKUP(D9,A!D9:J34,3,FALSE))+(VLOOKUP(D9,B!D9:J35,3,FALSE)))
=((VLOOKUP(D10,A!D9:J34,3,FALSE))+(VLOOKUP(D10,B!D9:J35,3,FALSE)))
=((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D9:J35,3,FALSE)))

Being that only the lookup_value in the two terms changes as it is
autofilled..
Thanks with any help..

[Kevin Vaughn]

=((VLOOKUP(D9,A!$D$9:$J$34,3,FALSE))+(VLOOKUP(D9,B!$D$9:$J$35,3,FALSE)))


--
Kevin Vaughn


"vicvega" wrote:

> I was working with a vlookup formula that I need to autofill down and have
> only one area of the function change, I have checked some past posts on
> autofilling and not found an answer,, I have also tried filling in a couple
> and using them as examples for autofill but has not worked,,,
>
> the desired results on the progressive cells would be:
>
> =((VLOOKUP(D9,A!D9:J34,3,FALSE))+(VLOOKUP(D9,B!D9:J35,3,FALSE)))
> =((VLOOKUP(D10,A!D9:J34,3,FALSE))+(VLOOKUP(D10,B!D9:J35,3,FALSE)))
> =((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D9:J35,3,FALSE)))
>
> Being that only the lookup_value in the two terms changes as it is
> autofilled..
> Thanks with any help..

[bpeltzer]

That's the difference between relative and absolute references. Change the
formula to
=((VLOOKUP(D9,A!$D$9:$J$34,3,FALSE))+(VLOOKUP(D9,B!$D$9:$J$35,3,FALSE)))

"vicvega" wrote:

> I was working with a vlookup formula that I need to autofill down and have
> only one area of the function change, I have checked some past posts on
> autofilling and not found an answer,, I have also tried filling in a couple
> and using them as examples for autofill but has not worked,,,
>
> the desired results on the progressive cells would be:
>
> =((VLOOKUP(D9,A!D9:J34,3,FALSE))+(VLOOKUP(D9,B!D9:J35,3,FALSE)))
> =((VLOOKUP(D10,A!D9:J34,3,FALSE))+(VLOOKUP(D10,B!D9:J35,3,FALSE)))
> =((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D9:J35,3,FALSE)))
>
> Being that only the lookup_value in the two terms changes as it is
> autofilled..
> Thanks with any help..

[vicvega]

Thanks ,, worked great

"bpeltzer" wrote:

> That's the difference between relative and absolute references. Change the
> formula to
> =((VLOOKUP(D9,A!$D$9:$J$34,3,FALSE))+(VLOOKUP(D9,B!$D$9:$J$35,3,FALSE)))
>
> "vicvega" wrote:
>
> > I was working with a vlookup formula that I need to autofill down and have
> > only one area of the function change, I have checked some past posts on
> > autofilling and not found an answer,, I have also tried filling in a couple
> > and using them as examples for autofill but has not worked,,,
> >
> > the desired results on the progressive cells would be:
> >
> > =((VLOOKUP(D9,A!D9:J34,3,FALSE))+(VLOOKUP(D9,B!D9:J35,3,FALSE)))
> > =((VLOOKUP(D10,A!D9:J34,3,FALSE))+(VLOOKUP(D10,B!D9:J35,3,FALSE)))
> > =((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D9:J35,3,FALSE)))
> >
> > Being that only the lookup_value in the two terms changes as it is
> > autofilled..
> > Thanks with any help..