If Vlookup matches an array, then pull the sum of corresponding values

[suman_gangi]

If the dropdown value of the list (weeks of an year) matches with a vlookup array of values, then the corresponding values have to be pulled AND, have to be summed up until the selected weeks of the year.

[#2]

@suman_gangi 

That could be

=SUM(
  INDEX(<A range>, MATCH(<week # range>, <weeks range>, 0) ):
  INDEX(<A range>, COUNTA(<week # range>)) )

[#3]

@suman_gangi 

=SUM(INDIRECT(("D3:D"&MATCH(F5,C3:C26,0)+2)))

Maybe with above formula as shown in attached file.