Please enable JavaScript to view the comments powered by Disqus.


SUM(...OFFSET(...A3,MATCH(...B12,A4:A10,0),0,1,5))

How to sum values returned by vlookup from the given range.

The formula relies on OFFSET() function because multiple values can not be returned by VLOOKUP or more accurately, VLOOKUP is unable to return range object. The thus returned values from the range is summed by SUM() formula. 


Used Functions

Category: Math and trigonometry

Adds its arguments

Syntax

SUM(number1,[number2],...)

Category: Lookup and reference

Returns a reference offset from a given reference

Syntax

OFFSET(reference, rows, cols, [height], [width])

Category: Lookup and reference

Looks up values in a reference or array

Syntax

MATCH(lookup_value, lookup_array, [match_type])

Lets chat on this