filling in column based on multiple criteria

[erickguz]

I searched the fanduel questions on this site without success. I dl a spreadsheet from fanduel fantasy baseball with the following columns. "Nickname" is the player's name. "Probable Pitcher" is the starting pitcher. Is there any way to place the following in Column Q?

1. you will notice that the last column is Probable Pitcher
2. the Probable Pitcher is designated with a "Yes"
3. the example below is Noah Syndergaard - he plays for the NYM
4. possible to create a formula and have the name Noah Syndergaard (Nickname) appear in COL Q next to any player that he is pitching against, in this case the NYY (designated as "Opponent")?
5. the spreadsheet has 14 Probable Pitchers, so I would like a formula that will place the name in COL Q of the pitcher that will pitch against that team.

I tried helper columns, just can't figure it out. Thanks for help.
-Erick

Position

First Name

Nickname

Last Name

FPPG

Played

Salary

Game

Team

Opponent

Injury Indicator

Injury Details

Probable Pitcher

<tbody>
</tbody>

P

Zack

Zack Greinke

Greinke

35.6

20

10300

COL@ARI

ARI

COL

P

Stephen

Stephen Strasburg

Strasburg

38.61538

13

10000

ATL@WAS

WAS

ATL

DL

Shoulder

P

Blake

Blake Snell

Snell

39.85

20

10000

MIA@TAM

TAM

MIA

P

Noah

Noah Syndergaard

Syndergaard

36.25

12

9800

NYM@NYY

NYM

NYY

Yes

P

Madison

Madison Bumgarner

Bumgarner

33.25

8

9600

SFG@OAK

SFG

OAK

P

James

James Paxton

Paxton

38.6

20

9500

CWS@SEA

SEA

CWS

DL

Back

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>