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!

You should be able to do that with a VLOOKUP

1 Like

@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:

Second sheet:

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))))`

2 Likes

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?

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))))}`

4 Likes

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.

3 Likes

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?

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.

4 Likes

Thanks Jeff, got it!

1 Like

And it works much faster than if you do it on the spreadsheet

1 Like

I know thats why I suggested it.