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 next nearest value from the list
It is quite strange though that in Google sheets I can make LOOKUP perform the data collection that I need - from one page to another but in Glide LOOKUP only gets the data from an exact match - see the first 2 columns in my Data Table.
I also have had to include a display column so that I can format the data that is in an IF,THEN,ELSE column…
Please feel free to look - test at my (test) app which has minimum fuctionality - just for testing this situation - entereing a value up to 66,000 will calculate at minimun fee of 6600 and a value above that is calculated on a banded sliding scale - but because it has to rely on the Google sheet for the LOOKUP it is quite slow
I love GLIDE !