Sport Team Fixture - Index/match?|General Excel Questions & Answers|Excel Forum|My Online Training Hub

https://ibb.co/cLGYD9 - Sheet 1 - A Team fixture (It could be any)

https://ibb.co/bxsOD9 - Sheet 2 - All the fixtures for every round.

On Sheet 1 - Cell E1 - To view any teams' fixture, I put in their name in this particular cell.

I need a formula for Cell J3 & J4 & S3.

In this example, there are 4 teams that have played in Round 1 - (1) Essendon, (2) St Kilda, (3) Melbourne and (4) Richmond.

I want it search Sheet 1 - Cell E1 for the team name, the team's name on Sheet 2, it's opponent name which is in the same colour box. and to display in Cell J3 & J4 - if they won or lost, and by how much.

Example for each team based on Sheet 1 - Cell E1.

(1) Essendon = Cell J3: "Won" - Cell J4: "72" - Cell S3: "14"

(2) St Kilda = Cell J3: "Lost" - Cell J4: "72" - Cell S3: "-14"

(3) Melbourne = Cell J3: "Lost" - Cell J4: "19" - Cell S3: "8"

(4) Richmond = Cell J3: "Won" - Cell J4: "19" - Cell S3: "-8"

I'm so sorry, this is poorly explained...