I know that we have LOOKUP but it would be great to have VLOOKUP I can use it in my Google sheet and it works just fine but it causes quite a delay in the app to fetch the data needed for other calculations that are made within the app itself. I need the function of LOOKUP or VLOOKUP to select the…

@Mike_Greene In the Glide Data Editor, have you tried the following “relation column + lookup”?

Yes I have - theye are the first 2 columns, BUT they only bring back a result if it is an exact match. I need the lookup to get the value as this : - [Screenshot 2020-05-29 at 12.59.49] As I said I can make this work with Google sheet either with LOOKUP or VLOOKUP Thanks

hi all I am still looking for a solution or hopefully to be informed that VLOOKUP may be on the list of future features!

Hi Mike, Can you log in to my test app and try out what’s in the NVP Test tab? [image] Link: https://tdslab.glideapp.io/

Hey … That works !! Can I Please see the workings ?

I have the Number Entry written to a user-specific column. [image] Then an If Then Else column to calculate the right barem to show. [image] [image] [image] This has nothing to do with the Barem range or the Barem pc column.

Hi I kind of understand… So in the way that I was doing this, each user would appear on their own line within the data table where the calculations were processed - Your table generates a row id - I need to try and understand this as I have not used it before… Again in my app, the emai address aut…

Hi Something strange Do you know why I do not get all of the options in the IF statement This is Yours [Screenshot 2020-06-03 at 17.05.05] This is Mine [Screenshot 2020-06-03 at 17.05.36] Thanks

Sorry it’s late here I will look further into your options tomorrow. The screenshot below looks like your column is a text column, not a number. Can you have a look into that?

Vlookup

Feature Requests

ThinhDinh June 3, 2020, 12:47pm 7

I have the Number Entry written to a user-specific column.

Then an If Then Else column to calculate the right barem to show.

This has nothing to do with the Barem range or the Barem pc column.

Topic		Replies	Views
Lookup Ask for Help	9	691	May 28, 2020
Display Lookup Column Data in Google Sheet Ask for Help	5	614	February 19, 2021
Can't use lookup column data for maps? Ask for Help	8	469	February 25, 2024
How to retrieve data after duplicating and relation in Google sheets Ask for Help	18	989	January 17, 2024
Random update lag Report a Bug	8	338	February 28, 2021

Vlookup

Related topics