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.




2 Replies


That could be

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




Maybe with above formula as shown in attached file.