selective autofill with functions

G

Guest

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

Guest

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

Guest

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

N/A results on vlookup with time calculations 4
Subtraction Function using cells with other functions in them 2
# of Functions per cell 3
help with multiple function from drop down box 6
Iserror with if(or & Vlookups 5
#N/A error with VLOOKUP function 3
Data Entry Form: Complex Example 4
Nested Functions with OR 5

Top