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,"")
Bookmarks