Placing a W/L on a football team result, regardless where the name is placed.

[jerry-garcia]

I want to use a formula, in column A & E, that will follow the team's name after I place a W/L result on the team's name in column A or E, regardless of where the name is located, and have that result in column V. Column U & V never changes, but B & D do.

 

[MikeVol]

@jerry-garcia,
What do we need help with based on the attached screenshot? Please attach an Excel file that matches your question.

 

[jerry-garcia]

@jerry-garcia,
What do we need help with based on the attached screenshot? Please attach an Excel file that matches your question.