Addition of two Relations (match simple)

[noneight]

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

[noneight]

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

5 colors to match with two column… -> 10

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

Is that a bug?

[Jeff_Hager]

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

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…