Hello,
I'm using some years now the following formula to lookup value:
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
I'm using some years now the following formula to lookup value:
VBA Code:
=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