# Lookup **URL:** \ **Category:** Ask for Help\ **Created:** [May 28, 2020, 3:04pm UTC](https://community.glideapps.com/t/lookup/9939 "2020-05-28T15:04:28Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 28, 2020, 3:04pm UTC](https://community.glideapps.com/t/lookup/9939/1 "2020-05-28T15:04:28Z")
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” [https://gxbh3.glideapp.io/](https://gxbh3.glideapp.io/) Thank you ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 28, 2020, 3:10pm UTC](https://community.glideapps.com/t/lookup/9939/2 "2020-05-28T15:10:10Z")
Might be easier to do a Glide relation-\>lookup data column instead. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 28, 2020, 3:41pm UTC](https://community.glideapps.com/t/lookup/9939/3 "2020-05-28T15:41:13Z")
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 ! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 28, 2020, 4:24pm UTC](https://community.glideapps.com/t/lookup/9939/4 "2020-05-28T16:24:08Z")
Looks like you got something to work! ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 28, 2020, 4:26pm UTC](https://community.glideapps.com/t/lookup/9939/5 "2020-05-28T16:26:10Z")
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 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 28, 2020, 4:29pm UTC](https://community.glideapps.com/t/lookup/9939/6 "2020-05-28T16:29:08Z")
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. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 28, 2020, 4:34pm UTC](https://community.glideapps.com/t/lookup/9939/7 "2020-05-28T16:34:37Z")
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… ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 28, 2020, 4:43pm UTC](https://community.glideapps.com/t/lookup/9939/8 "2020-05-28T16:43:21Z")
Just strange that LOOKUP works from one sheet to another in GOOGLE =LOOKUP(D22,‘Mandate fees’!$A$2:$B$8) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 28, 2020, 4:55pm UTC](https://community.glideapps.com/t/lookup/9939/9 "2020-05-28T16:55:01Z")
Exactly. If the lag gets frustrating, I could craft you a solution that uses glide columns instead. ---
**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\ **Post date:** [May 28, 2020, 5:09pm UTC](https://community.glideapps.com/t/lookup/9939/10 "2020-05-28T17:09:59Z")
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 …