Hi

Maybe the following although I'm not entirely sure I understand your requirement and if not manually add the results you expect for various permuations so that we may see the end goal.


As an array formula in C5 (entered with Ctrl Shift Enter) copied down.
Formula: copy to clipboard 
=IF(MAX(('My Data'!$B$3:$B$20=B5)*('My Data'!$E$3:$E$20))-30>0,"",B5)