selective autofill with functions

V

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..
 
B

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)))
 
V

vicvega

Thanks ,, worked great

bpeltzer said:
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)))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a great number of words in word files, with a macro as short as possible. 5
Using IF function then Autofill-increments down a reference cell 2
Vlookup to reference offset 1
How can find a value using two different matching criteria? 6
Subtraction Function using cells with other functions in them 2
Stripe out duplicate data 5
Indirect inside a vlookup 3
combine three if functions 3

Top