# Addition of two Relations (match simple)

**URL:** <https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052>\
**Category:** Ask for Help\
**Created:** [July 24, 2020, 2:51pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052 "2020-07-24T14:51:38Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\
**Post date:** [July 24, 2020, 4:35pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/21 "2020-07-24T16:35:05Z")

</div>

I did but as you see the count is not good.

 ![TEST3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/78b8fef7f600404737e97505c72d22b62adf3598.gif)

---

<div class="post-metadata">

**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\
**Post date:** [July 24, 2020, 4:46pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/22 "2020-07-24T16:46:13Z")

</div>

First row, i should have had 10 items, i just have 6.

5 colors to match with two column… -\> 10

 ![TEST3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/42b122ff4857a370dbe9d4a7133d4e68a166818e.gif)

It looks like it doesn’t take the value if he did before

Is that a bug?

---

<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:** [July 24, 2020, 5:00pm UTC](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052/23 "2020-07-24T17:00:25Z")

</div>

If your lookup is to an array column, it won’t pull back all of the values. I requested for an array to load into a lookup array awhile back, but I don’t think anything was ever resolved with that.

> [@Lookup against an array of column](https://community.glideapps.com/t/lookup-against-an-array-of-column/3352):
>
> I’m not sure if this is a bug, but I have a sheet with 2 email columns ‘Email 1’ and ‘Email 2’. I am attempting to create a relation column within the same sheet that links the Email array to the same Email array. I know this seems weird, but I’m doing this to pull back a relation of all rows that contain at least one of the two emails. The relation appears to be working just fine. What I want to do is then create a Lookup column against the relation that pulls back every email, from the Ema…

[Previous page](https://community.glideapps.com/t/addition-of-two-relations-match-simple/13052.md?page=1)
