If A1 is present in column B, get C. How do I make it?

I have “Car” in a sheet, on another sheet I have two columns with “Vehicle” (Car, Bike, Train, etc) and one list with “Wheels” (4, 2, 34, etc).

I’d like the sheet to give me 4 in the cell next to “Car”.

I’m new to sheets. Thanks if you will help. Happy holidays.

You could do that with a vlookup

If you have header in line 1.
Use this method - in cell b2:

1 Like

They are not in the same sheet so the correspondant of A2 in one sheet could be B16 and not B2

in sheets? How?

Can share a screenshot? Please

replace with…


I actually learned a great deal from this post by @ThinhDinh

There are some really great tips in here and best practices to follow.

Vlookup worked, thanks.

Should arrayformula have worked too?

1 Like

Since I’m here, how do I apply a formula to the whole columns including future new rows?

Here is an example with the formula starting in the header row.


Note: Don’t forget the } at the end of the formula :sunglasses:


Thx a lot, it works.

So arrayformula is a powerful magic i suppose…


That’s great! I’m glad I could help you and Happy Holidays to you too!

Yes the array formula is very powerful. It’s always best to start in the header rows and to use iferror or if(isblank type logic when building your formulas.

1 Like

I’m now trying other formulas I need to apply to whole columns but it only does it for the first row:
={“Header”;arrayformula(iferror(JOIN(" - “;G2;E2;F2;W2;O2;C2;D2);”"))}
If I add the G2:G; etc, i get all the joins in one cell.

However, it’s late here, and these things are mind energy expensive ^^ thx again, to the next one!

Maybe try to use concatenate function instead?..this is a little above my pay grade :stuck_out_tongue_winking_eye:

Is there any reason for not doing any of this within the Glide data editor with relations, lookups, templates, etc?


The only reason I ever use vlookups is for data sets that have too many rows for us to attach to glide.

Other than that Jeff makes a good point here.


Seems like it should be

={“Header”;arrayformula(IF(A2:A="";"";G2:G&" - "&E2:E&" - "&F2:F&" - "&W2:W&" - "&O2:O&" - "&C2:C&" - "&D2:D))}
1 Like

I thought I wanted to keep the data in sheets, and learn how to do it if I’d need it, and I thought I might have needed additional columns in glide, and I have way too many.

And, most of all, I can’t convert a normal column into a glide column, so now if I want to use the newly made one, I will have to manually go and change it in ALL of the parts of the app that use that column, can you confirm that for me or is there a way to save me from this?

No, that’s fine. There’s nothing wrong with doing any of that in the google sheet if you need it there and that’s what you prefer. I just wanted to make sure that you were aware of the option.

In my opinion, setting some of that stuff up with Glide columns is easier, more flexible, and future proof compare to writing formulas. Also glide columns will give you instant results instead of waiting for data to sync from the app to the glide servers, then to the sheet, run through the formulas, then sync back to the glide servers, then finally sync back to the app. It’s usually only a few seconds, but it’s not instant like glides computed columns which happen directly on the device itself. It’s just better to consider your options sooner rather than later when your app gets larger and more complex.

My app was built before there was even a glide data editor, so a lot of it originally used a lot of arrayformulas, queries, and other google sheet logic. I’ve slowly been converting to glides computed columns, which has sped things up a lot, but it’s very tedious to switch components over to new columns. So, I understand if you don’t want to mess with any logic you already have in place.

Again, just making sure you were aware of the option.


Ok, thx for the information, that’s appreciated.
Will keep that in mind.

1 Like