# Google Sheets Question **URL:** \ **Category:** Ask for Help\ **Created:** [December 11, 2020, 12:18pm UTC](https://community.glideapps.com/t/google-sheets-question/19710 "2020-12-11T12:18:04Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 11, 2020, 12:18pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/1 "2020-12-11T12:18:04Z")
Hi! Not sure if this is possible but thought I might as well ask before scouring the internet for hours on end with no answer. I have a tab within my google sheet that has the name of a business, and its neighborhood in the same row. I have another tab within that same sheet where I am adding businesses based on certain criteria. There is a neighborhood column in there as well. My question is: Is there a way where when I add a specific business, the neighborhood it’s tied to in the first tab automatically populates in this second neighborhood column in this second tab? Maybe some type of formula? Thanks! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 12:21pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/2 "2020-12-11T12:21:17Z")
You should be able to do that with a VLOOKUP ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 12:58pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/3 "2020-12-11T12:58:33Z")
@Jen_NYCP, apologies for the very terse reply just now, I was about to sit down and eat my dinner, so just wanted to give you a quick clue 😀 Here is an example of how it might work. First sheet: ![Screen Shot 2020-12-11 at 8.53.55 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc57a1ab49854243a77dd5d4c73575a44249ea00.png) Second sheet: ![Screen Shot 2020-12-11 at 8.54.14 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbf1ff9110c5bd64c67e9ba6752c61cb33eb5483.png) Formula used in the second sheet (assumes the name of the first sheet is ‘Business Neighborhoods’): `=ARRAYFORMULA(IF(A2:A="","",(VLOOKUP(A2:A, 'Business Neighborhoods'!A:B,2,FALSE))))` ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 11, 2020, 1:07pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/4 "2020-12-11T13:07:07Z")
Haha no worries. Oh ok! This looks good, let me give it a try, I would be adding this to the header of column B correct? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 11, 2020, 1:16pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/5 "2020-12-11T13:16:21Z")
Actually no, in that example I have it in row 2. If you want it in the header row (which is probably better), then use this: `={"Neighborhood";ARRAYFORMULA(IF(A2:A="","",(VLOOKUP(A2:A, 'Business Neighborhoods'!A:B,2,FALSE))))}` ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 11, 2020, 2:58pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/6 "2020-12-11T14:58:53Z")
Is there a reason you want this relation to exist in the sheet and not in Glide? You can create these relationships in Glide and pull the entire neighborhood list in that manner and in doing so speeding up that query. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 11, 2020, 8:14pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/7 "2020-12-11T20:14:45Z")
Hmm true, I’m not too sure which column type and configuration I would need for that. Do you have an idea of what that would look like? ---
**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:** [December 11, 2020, 9:33pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/8 "2020-12-11T21:33:34Z")
It would just be a single relation in your second sheet to the first sheet using business name. Then a lookup column to get the neighborhood out of the relation. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [December 12, 2020, 4:29pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/9 "2020-12-12T16:29:16Z")
Thanks Jeff, got it! ---
**Author:** ![PabloMFalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablomfalero/32/31166_2.png) [@PabloMFalero](https://community.glideapps.com/u/PabloMFalero)\ **Post date:** [December 12, 2020, 4:47pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/10 "2020-12-12T16:47:30Z")
And it works much faster than if you do it on the spreadsheet ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 12, 2020, 6:42pm UTC](https://community.glideapps.com/t/google-sheets-question/19710/11 "2020-12-12T18:42:44Z")
I know thats why I suggested it.