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...
Hi,
I have difficulties in grasping what it is you want, but if you can upload a sample file with the data as you show in your pictures I have a chance to get a better understanding of what it is you are trying to build. I might have serious difficulties anyway, as I don't know the rules and scores of cricket. 🙂
Br,
Anders
The cells in red are the ones I'm trying to workout formulas for.
Sorry, I didn't realise the upload didn't work. It apparently exceeds the maximum size. Hopefully this works.
