# Relation from multiple values (Data)

**URL:** <https://community.glideapps.com/t/relation-from-multiple-values-data/3945>\
**Category:** Feature Requests\
**Created:** [January 24, 2020, 11:19pm UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945 "2020-01-24T23:19:42Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 25, 2020, 12:03pm UTC](https://community.glideapps.com/t/relation-from-multiple-values-data/3945/4 "2020-01-25T12:03:35Z")

</div>

Check out this thread:

> [@How to create a relation which compares with multiple columns in other sheet](https://community.glideapps.com/t/how-to-create-a-relation-which-compares-with-multiple-columns-in-other-sheet/2592):
>
> 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 To [SmartSelect\_20191203-113729\_Sheets]

---

_[View the full topic](https://community.glideapps.com/t/relation-from-multiple-values-data/3945)._