LibreOffice Calc - 220.127.116.11 (Ubuntu 16.04)
If a value from a range1 in table1 is also found in range2 in table2,
the value from range1 in table 1 gets a special formatting.
In other words:
If a soccer team in (=table1.range1) ranks among the top three in (table2.range2),
I want that team to receive a special formatting.
I’ve tried MATCH(“search criterion”;lookup_array),
but I don’t get the desired results.
[Edit Opaque] Moved attachment from answer and deleted answer.