Use of Lookup for scorelines

[ladbroke]

Hi,

I have attached an example sheet of what I am trying to explain, and achieve.

On one page I have fixtures/results and on another page I have scorecheck.

What I would like is for a formula, and I assume some form of Lookup is best, in cell A2 on Scorecheck (where the scoreline 6-1 is) to look up in Fixtures-Results all results for the team in A1 (in this case its Team A).
It would need to check both column A and D as they can play home or away. I would really like it if the teams goals scored was mentioned first (6) then a ' - ' then the opponents goals scored (1). For every new result, it uses a new cell below the last.

Hopefully its achievable.

[RobertMika]

Does this help?