I need to solve this:
Sheet A (games) has 2 Columns with, “Home team ID” and "Away Team ID"
Sheet B (Teams) has a column with “ID of the team”
I want to relate Teams to the games their in in ONE list. So I need relate Teams to 2 colums of Games which both can contain the team ID.
Does anyone know a fix? Having a new sheet with a beast of an array-kind-of-formula is also good if this fixes it XD