Obtain email or row with IF-CodePudding

I have a list of emails and information like this:

To take an example let's focus in yellow rows so each institution has their own area and the corresponding person to it, now the second part each person has a percentage, what I'm trying to do is I have a table with this percentage for each ID institution, if one are has less than 0.8 give me the email, something like this:

=IF(C2<=0.8, "[email protected]", "")

Like this image:

In column J:N is the expected result I was trying with this formula:

=IF(C2<=0.8,(FILTER(Email!$D$2:$D$12,Email!$A$2:$A$24=B2,$D$2:$D$12<>""),""), "NO")

But no results, help please!

CodePudding user response：

try:

=ARRAYFORMULA(FILTER(Email!A2:E, IFNA(VLOOKUP(Email!A2:A&Email!C2:C, 
 SPLIT(FLATTEN(Condition!B2:B&Condition!C1:F1&"×"&Condition!C2:F), "×"), 2, 0))<=0.8))

update:

=ARRAYFORMULA(FILTER(Email!A2:E, IFNA(VLOOKUP(Email!A2:A&Email!C2:C, 
 SPLIT(FLATTEN(Condition!B2:B&Condition!C1:F1&"×"&Condition!C2:F), "×"), 2, 0))<=0.8, 
 IFNA(VLOOKUP(Email!A2:A&Email!C2:C, 
 SPLIT(FLATTEN(Condition!B2:B&Condition!C1:F1&"×"&Condition!C2:F), "×"), 2, 0))<>""))