Results and League tables

I would add a new column (which you can hide) to create a combined team name identifier. select column A and insert a new column before by using the key combaination:

<command> + <option> + <left arrow>

A2=C2&"_v_"&H2

select A2 and fill down as needed.

For the bottom table ( I am assuming the name of the top table is "Games"... adjust this name in my formulas to match your table name OR change your table name to match):

I would unmerge the columns and use a single column for a team. Like this:

C2=IF(C$1=$B2, "EMPTY",IFERROR("<"&VLOOKUP(C$1&"_vs_"&$B2, Games::$A:$F, 5, 0)&"< "&"^"&VLOOKUP(C$1&"_vs_"&$B2, Games::$A:$F, 6, 0)&"^", "--"))

select C2, copy,

select C2 thru the end (in my example H7), paste

Now seelc the menu item "Format > Conditional Formatting" and set up like this:

I meant to mention...

I placed braces around the scores to direct you whose was whose...

e.g.:

<1< ^2^

is indicating that the 1 belongs to John

and 2 belongs to Wayne

This actually identifies a typo I have.... those should be reversed:

use this formula instead

=IF(C$1=$B2, "EMPTY",IFERROR("^"&VLOOKUP(C$1&"_vs_"&$B2, Games::$A:$F, 5, 0)&"^ "&"<"&VLOOKUP(C$1&"_vs_"&$B2, Games::$A:$F, 6, 0)&"<", "--"))

This is what it should look like:

Here is a link to you corrected document

I meant to actually include the link:

https://www.dropbox.com/s/5jol6ywmz4uizpi/Results_WLC.numbers