Extend formula VLOOKUP to find multiple vallues

[emoes]

Hello,

I'm using some years now the following formula to lookup value:

=IF(ISERROR(VLOOKUP($D2;Invoice!K:L;2;FALSE));"_ONBEKEND";VLOOKUP($D2;Invoice!K:L;2;FALSE))

I would like to extend the formula with "SUM" so if the Search value (in this case D2) is found multiple times in Columns K:L it will sum up the amount instead of only return the first found value.
My knowledge about formulas is not that good that I can add this myself.

Thnkas for your help.
Emoes

 

[Fluff]

How about

=SUMIFS(Invoice!L:L,Invoice!K:K,D2)

 

[emoes]

How about

=SUMIFS(Invoice!L:L,Invoice!K:K,D2)

Hello Fluff,
Thanks for your quick reply. This works good.
I actually like also "my" formula, because it's not finding the search value it will return "_Onbekend" and is also preventing an error code.
So it is nice to have if both could be combined. But as said, yours is doing what I asked.

Emoes

 

[Fluff]

The sumifs should not give an error and if the D2 value is not found the formula should return 0

 

[emoes]

Check...
Thanks again for your reply.

Alex

 

[Fluff]

You're welcome & thanks for the feedback