Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...D4:D10=B12)*(...A3:C3=B13)*A4:C10)

How to vlookup to the left side of a table.

VLOOKUP() function allows looking values to the right side of the criteria_column, we can't go the left side of it. There are various alternatives you can follow for this problem, one is to use combination of INDEX() or OFFSET() and MATCH(), second is to use VLOOKUP() with choose, the most easy one is to SUMPRODUCT() to validate the criteria and return the result. The formula works by checking in the header row the desired result and gives value to the left of the criteria column.   


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

SUMPRODUCT(array1, [array2], [array3], ...)

Lets chat on this