vlookup with multiple source and target columns

Originally Posted by avk

Since in column "H" & "I" no duplicate > use in "E3"

Formula:

=SUMPRODUCT(($H$3:$H$19=A3)*($H$3:$H$19=B3)*($J$3:$J$19))+SUMPRODUCT(($I$3:$I$19=C3)*($I$3:$I$19=D3)*($J$3:$J$19))

thanks avk, but did not work.. also, it's possible to have duplicates in columns H & I, but i can easily remove if required.

Capture.JPG