selective autofill with functions
 

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!D 9:J35,3,FALSE)))
=((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D 9:J35,3,FALSE)))

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

selective autofill with functions
 

=((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!D 9:J35,3,FALSE)))
=((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D 9:J35,3,FALSE)))

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

selective autofill with functions
 

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!D 9:J35,3,FALSE)))
=((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D 9:J35,3,FALSE)))

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

selective autofill with functions
 

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!D 9:J35,3,FALSE)))
=((VLOOKUP(D11,A!D9:J34,3,FALSE))+(VLOOKUP(D11,B!D 9:J35,3,FALSE)))

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