I'm looking to do a formula and cannot seem to find any help online. Everything I found returns a specific word or number specified by "".

I have a scenerio that needs to put specific text (from a drop down box) into another cell ONLY if a cell that refers to that cell says "Yes"(also chosen from a drop down box. Below is an example.

Team A. Team B. Team C.
Yes. No. No

Cell E4 NEEDS TO SAY: Team A
Because it was the only option that has Yes in the cell below it.

This formula spits out the correct answer if you only chose one scenerio but when u try to involve all 3 teams it gives me errors.
=IF(B8="YES",B4) the answer will show Team A like it's supposed to.

I've tried all the formulas I know of (IF,IFS,OR,INDEX,LOOKUP,VLOOKUP,IFSERROR,etc.) and can't come up with the answer. Please help!
thanks
Dustin