Relation from multiple values (Data)

[Jeff_Hager]

Check out this thread:

How to create a relation which compares with multiple columns in other sheet

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 [SmartSelect_20191203-113718_Sheets] To [SmartSelect_20191203-113729_Sheets]