Your results are incorrect

You say
If user input in cell B2 (your example sheet says the user input is in B1)


...match value in column 2
If column 3 = D
If flag value >=1

then output should be

A 1
G 2


Considering rows where column A = G
Row 6 column B does not B1
Row 7 column 3 does NOT = D

so the only output would be

A 1

no G's

This formula works
=IF(AND(B4=B$1,C4="D",E4>=1),A4,"")