Home > Back-end >  Arrayformula with multiple VLOOKUP conditions doesnt work correctly
Arrayformula with multiple VLOOKUP conditions doesnt work correctly

Time:01-02

I need a list with all revenues matching multiple conditions (country abbr & year/month with wildcard) using vlookup and an arrayformula like this one:

=SVERWEIS(1;{ARRAYFORMULA((Tabellenblatt2!A:A=A5&"*")*(Tabellenblatt2!B:B=A1));Tabellenblatt2!C:C};1;FALSCH)

This doesnt work. I dont know why. Here is the google sheet document where I test it: enter image description here

the same came be done via FILTER()

=SUM(IFERROR(FILTER(Tabellenblatt2!C:C;EOMONTH(Tabellenblatt2!A:A;0)=EOMONTH(DATE(A3;A2;1);0);Tabellenblatt2!B:B=A1)))

IF you just need the values list then:

=FILTER(Tabellenblatt2!C:C;EOMONTH(Tabellenblatt2!A:A;0)=EOMONTH(DATE(A3;A2;1);0);Tabellenblatt2!B:B=A1)

enter image description here

  • Related