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 Email array, of every row that contains one of those emails. The problem I have is that I can only pull back either Email 1 or Email 2 into the Lookup column even though it appears that the email array is one of the options for the lookup. I don’t know if this is a programming limitation where I can’t pull an array of values into an array lookup column or a bug. What I’m trying to do is create a lookup column that can be used for per user data so a user can view all rows where there is at least one common email among all of the rows.

This is my attempt at a simple way to resolve the issue below. I think I could do this with 2 identical sheets and ultimately just the relation column I created. One sheet for per user data, and then the second sheet for the relation to an inline list. I was hoping to come up with a simpler method that didn’t require 2 sheets.

Edit: I forgot to post the thread that I was referring to.