2 ANSWERS, 1 cell

I will try my best explain...

CELL E3 CONTAINS THIS IF FORMULA...

=IF(D3="OUT","YES","NO")

NOW I NEED E3 TO RETURN "NO" IF D3="OUT" AND A3 IS A MATCH IN G3:G13 & STILL BE ABLE TO RETURN "YES" IF D3="OUT"

I HOPE THIS EXPLAINS IT.