# Lookup of followers **URL:** \ **Category:** Ask for Help\ **Created:** [May 24, 2020, 11:02am UTC](https://community.glideapps.com/t/lookup-of-followers/9674 "2020-05-24T11:02:58Z")\ **Posts on this page:** 1\ **Showing post:** 6
**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:** [May 25, 2020, 9:30pm UTC](https://community.glideapps.com/t/lookup-of-followers/9674/6 "2020-05-25T21:30:26Z")
The screenshots didn’t help me much since everything was blurred out and it was hard for me to mentally map how everything was related. I think I’m also missing how the followers are attached to users. But if I understand what I think you are asking, you essentially want to create an array of all followers from all users who have written reviews for a location. You can easily create the relation from Locations to Reviews, do a lookup of User name, then create a relation from the lookup to the User’s sheet. I think where you run into the problem…and I’ve seen this before…is that you cannot create a lookup that creates an array of arrays together. I posted about this situation awhile back while helping somebody else, but it never evolved into anything beyond that. Maybe this would be a case for a feature request. > [@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… As an alternative, maybe you could try to think backwards and create your relation from the users to the reviews sheet, then a lookup to get the location and then create a direct relation from location to users. Again, I think I’m missing something to completely picture this. Also, kind of mentally out of it today. Also take a look at this to create a default value to use for a relation only when the signed in user is following a user who review a location. I think you could set it up so an if/then colum will only be filled, possibly with the signed in user’s email, when the signed in user’s email is found in the follower’s array (might need a template of signed in user’s email, to a relation in the followers array, to an if/then column that checks if the relation is empty or not and returns user email). Then you could use your original thought or some of the ideas I presented to build your email array on the locations sheet, but it would only contain the signed in user’s email for the relavant locations they can see. > [@List Relation "Data"](https://community.glideapps.com/t/list-relation-data/7659/5): > > BAM! I figured it out. First create an If/Then column on the user profile sheet that fills the column with the word ‘Name’ if signed in user. Next, on every sheet you want to display the name: Create a template column that contains the word ‘Name’. Create a relation column that joins the name template to the name template in the user profile sheet. Create a lookup column that gets the name from the relation. Bonus - make it look pretty. [image] [image] --- _[View the full topic](https://community.glideapps.com/t/lookup-of-followers/9674)._