Hello everyone,
I’m struggling to find a solution to that problem:
I have 1 glide table with an admin column that corresponds to every user.
Then another table (google sheets) with that same column (not same order) plus another column that I want to “copy” in the glide table (the values should update so that’s not a one-time copy).
I tried with relation using the in-common column, but I can’t choose to import only the column I’m looking for, and relation is a component I can’t use with action text for example…
Summarizing…
How am I supposed to do a simple VLOOKUP on glide tables?
Thanks…
I’ve just seen a post of someone asking if glide isn’t getting too much complicated/less beginner friendly… spoiler, it is… don’t overengineer further please, copy all excel functions that are missing
I mean… I saw a “Kebab case” function…
I tried multiple times but lookup copies all the relation column data in one cell… my relation is single (1 user in glide table = 1 user in google sheet)
In the configuration of the lookup column, under relation column, you should have a relation at the root level called “New Column A” (not the one under “Home”). Could you select that relation?
Just a thought, in your screenshot your first value is a Text column and you’re matching with an Email column. It may be wise to change the text column’s format to email and then your relation may be more successful in finding the appropriate match.
For a relation to work in Glide, the two values must match perfectly (a capital on one side of the relation and not the other will not lead to a match, for example). Once this relation is set up properly, you can add a Lookup column to “look up” the data that is found in the matched row. From there, you can select one of the columns from that table to pull that value into the other table.
