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:
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)