=((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..