I did but as you see the count is not good.
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?
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.
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ā¦
