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



[TABLE="width: 832"]
<tbody>[TR]
[TD="width: 64"]Position[/TD]
[TD="width: 64"]First Name[/TD]
[TD="width: 64"]Nickname[/TD]
[TD="width: 64"]Last Name[/TD]
[TD="width: 64"]FPPG[/TD]
[TD="width: 64"]Played[/TD]
[TD="width: 64"]Salary[/TD]
[TD="width: 64"]Game[/TD]
[TD="width: 64"]Team[/TD]
[TD="width: 64"]Opponent[/TD]
[TD="width: 64"]Injury Indicator[/TD]
[TD="width: 64"]Injury Details[/TD]
[TD="width: 64"]Probable Pitcher[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 832"]
<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]P[/TD]
[TD="width: 64"]Zack[/TD]
[TD="width: 64"]Zack Greinke[/TD]
[TD="width: 64"]Greinke[/TD]
[TD="width: 64, align: right"]35.6[/TD]
[TD="width: 64, align: right"]20[/TD]
[TD="width: 64, align: right"]10300[/TD]
[TD="width: 64"]COL@ARI[/TD]
[TD="width: 64"]ARI[/TD]
[TD="width: 64"]COL[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]Stephen[/TD]
[TD]Stephen Strasburg[/TD]
[TD]Strasburg[/TD]
[TD="align: right"]38.61538[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]10000[/TD]
[TD]ATL@WAS[/TD]
[TD]WAS[/TD]
[TD]ATL[/TD]
[TD]DL[/TD]
[TD]Shoulder[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]Blake[/TD]
[TD]Blake Snell[/TD]
[TD]Snell[/TD]
[TD="align: right"]39.85[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]10000[/TD]
[TD]MIA@TAM[/TD]
[TD]TAM[/TD]
[TD]MIA[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]Noah[/TD]
[TD]Noah Syndergaard[/TD]
[TD]Syndergaard[/TD]
[TD="align: right"]36.25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9800[/TD]
[TD]NYM@NYY[/TD]
[TD]NYM[/TD]
[TD]NYY[/TD]
[TD][/TD]
[TD][/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]Madison[/TD]
[TD]Madison Bumgarner[/TD]
[TD]Bumgarner[/TD]
[TD="align: right"]33.25[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9600[/TD]
[TD]SFG@OAK[/TD]
[TD]SFG[/TD]
[TD]OAK[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD]James[/TD]
[TD]James Paxton[/TD]
[TD]Paxton[/TD]
[TD="align: right"]38.6[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]9500[/TD]
[TD]CWS@SEA[/TD]
[TD]SEA[/TD]
[TD]CWS[/TD]
[TD]DL[/TD]
[TD]Back[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]