Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill but with a custom rule?? | Excel Discussion (Misc queries) | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |