Lookup

Hi all
I feel that I am so nearly there - I am trying to get LOOKUP to work - and I can make it work within Google sheets but not in Glide - I have watched the video and although it sounds easy …!

I am trying to get LOOKUP to work like this - =LOOKUP(D2,‘Mandate fees’!$A$2:$B$8)
This formula works in the Google sheet, Column I, but I cannot make it work in the DATA section of Glide
I want it to action this in the column “Afetch fees”

Thank you

Might be easier to do a Glide relation->lookup data column instead.

Hi Robert
That is what I was trying to do - I set up a test app just to experiment with
I created a new column which is a realtion column and also a Lookup column and that is where I am stuck - Not sure which columns to link to what !

Looks like you got something to work!

I have managed to get some data into the cell BUT I it is only looking for an exact match rather than using it as a range as it should - and as it does if I put the formula in the Google sheet

Right…a Vlookup formula can get the closest match, a relation looks for an exact match. You’ll need to create a more complicated setup using some if then columns, possibly a template column merging your if-then values and then relating it to a template column in the other sheet. Not easily done, but it is possible.

Ok - I am begining to see why you set it up initially using VLOOKUP - within the Google sheet -
I just thought I would give it a try after getting success using math and IF columns - and seeing instant calculated results in the app.
The original one (that you setup for me) is great and I have added many other functions and everyone is really pleased except that it can take a few seconds to calculate
thanks anyway…

Just strange that LOOKUP works from one sheet to another in GOOGLE

=LOOKUP(D22,‘Mandate fees’!$A$2:$B$8)

Exactly. If the lag gets frustrating, I could craft you a solution that uses glide columns instead.

Hi
I will keep trying first to see how far I can get - I just reiterate though that it is strange that LOOKUP, as well as VLOOKUP, works correctly within Google …