Addition of two Relations (match simple)

[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…