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

Occasional Visitor

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.

 

suman_gangi_2-1641304117981.png

 

2 Replies

@suman_gangi 

That could be

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

@suman_gangi 

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

 

Maybe with above formula as shown in attached file.