# Vlookup **URL:** \ **Category:** Feature Requests\ **Created:** [May 29, 2020, 10:13am UTC](https://community.glideapps.com/t/vlookup/9973 "2020-05-29T10:13:31Z")\ **Posts on this page:** 20\ **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 29, 2020, 10:13am UTC](https://community.glideapps.com/t/vlookup/9973/1 "2020-05-29T10:13:31Z")
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 > **[lookup tester](https://test-lookup.glideapp.io/)** > > test0 I love GLIDE ! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 29, 2020, 10:24am UTC](https://community.glideapps.com/t/vlookup/9973/2 "2020-05-29T10:24:40Z")
@Mike_Greene In the Glide Data Editor, have you tried the following “relation column + lookup”? ---
**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 29, 2020, 11:01am UTC](https://community.glideapps.com/t/vlookup/9973/3 "2020-05-29T11:01:51Z")
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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b4addcd53cd2453a716421f0afbf5222644c099a.png) As I said I can make this work with Google sheet either with LOOKUP or VLOOKUP Thanks ---
**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:** [June 3, 2020, 12:00pm UTC](https://community.glideapps.com/t/vlookup/9973/4 "2020-06-03T12:00:32Z")
hi all I am still looking for a solution or hopefully to be informed that VLOOKUP may be on the list of future features! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2020, 12:19pm UTC](https://community.glideapps.com/t/vlookup/9973/5 "2020-06-03T12:19:12Z")
Hi Mike, Can you log in to my test app and try out what’s in the NVP Test tab? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d34818ca662b1aeca0b37bbc3d9a2f40a56c6f08.png) Link: [https://tdslab.glideapp.io/](https://tdslab.glideapp.io/) ---
**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:** [June 3, 2020, 12:36pm UTC](https://community.glideapps.com/t/vlookup/9973/6 "2020-06-03T12:36:10Z")
Hey … That works !! Can I Please see the workings ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2020, 12:47pm UTC](https://community.glideapps.com/t/vlookup/9973/7 "2020-06-03T12:47:42Z")
I have the Number Entry written to a user-specific column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/79d662402a3fc656139c89fe1b3741ca9e1628c0.png) Then an If Then Else column to calculate the right barem to show. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dd130d4c7d5262b33b6acbc60d8a31ca290324a0.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1b4cda0235549a8f9fa4b91e6af2d49531f8d746.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f59936da1406ddf527429dd6de881ac9b31ba9bf.png) This has nothing to do with the Barem range or the Barem pc column. ---
**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:** [June 3, 2020, 1:36pm UTC](https://community.glideapps.com/t/vlookup/9973/8 "2020-06-03T13:36:35Z")
Nice solution…so simple. ---
**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:** [June 3, 2020, 1:42pm UTC](https://community.glideapps.com/t/vlookup/9973/9 "2020-06-03T13:42:37Z")
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 automatically goes into the fist page of my Google sheet and so takes up a row for each user… I see that on your app the email addres goes to the Profile page - so is the row id in the Profile page related to the row id in the Lookup Test page ? What is the function of the row id in the Lookup Test page. As I said I will have a play and I really appreciate your input and any firtyher help will be really appreciated Thanks ---
**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:** [June 3, 2020, 3:59pm UTC](https://community.glideapps.com/t/vlookup/9973/10 "2020-06-03T15:59:51Z")
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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/103b371be1e5b45aacd1ada4e36590ab27295d30.png) This is Mine ![Screenshot 2020-06-03 at 17.05.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5b0f86f102726244b915e3bffa20d6895c5bef0e.png) Thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2020, 4:05pm UTC](https://community.glideapps.com/t/vlookup/9973/11 "2020-06-03T16:05:48Z")
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? ---
**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:** [June 3, 2020, 4:18pm UTC](https://community.glideapps.com/t/vlookup/9973/12 "2020-06-03T16:18:23Z")
Thanks I have tried all kinds of columns- all seem to give same options - I will keep trying / have a good evening And keep safe. Where are you ? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 3, 2020, 4:25pm UTC](https://community.glideapps.com/t/vlookup/9973/13 "2020-06-03T16:25:59Z")
I’m from Vietnam, Mike. Glad to help you and hopefully I’ll have time for your case tomorrow. It’s 11.30pm here already. ---
**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:** [June 3, 2020, 4:26pm UTC](https://community.glideapps.com/t/vlookup/9973/14 "2020-06-03T16:26:41Z")
Hey thanks and get som e sleep ! I have tested and I can only make it work on a number column - NOT on an IF THEN ELSE or Math Column Hope to hear from you tomorrow… ---
**Author:** ![Tim\_Sullivan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tim_sullivan/32/3461_2.png) [@Tim\_Sullivan](https://community.glideapps.com/u/Tim_Sullivan)\ **Post date:** [June 3, 2020, 8:31pm UTC](https://community.glideapps.com/t/vlookup/9973/15 "2020-06-03T20:31:13Z")
On the left hand side of the builder, select the data icon. You’ll build the IF statement there. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3aed63169a18831e7cfeb324d7e0c5cce515b1fa.png) On the right, select the blue plus sign to create a new column. Under Column Type - choose If - Then - Else. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/77168dd58aab7dbadc06a44e7258b678b98b2796.png) Follow the example here. Keep adding a case until you’ve included all your tests. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6087c55caf81816ca5336c77481a0360f2e2b4ad.png) ---
**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:** [June 4, 2020, 10:27am UTC](https://community.glideapps.com/t/vlookup/9973/16 "2020-06-04T10:27:29Z")
Hi Yes I understand this (now!) but what I am saying is that I can’t run an IF math function on another IF THEN ELSE column - only on a Number Column So I have tried this: Created a Math column that is just a link to an IF THEN ELSE Column so it just displays the resuly… However I still cant get the math function in another IF THEN ELSE Column to work on the math column. BUT if the Math column is displaying the data from a number column then I get all of the maths functions To see what I mean… please look at my test app and Bareme 2 - Check the columns : - Test Math 1 +Test IF 1 & Test Math 2 + Test IF 2 > **[Bareme method 2 V2](https://gobaremeter.glideapp.io/)** > > Based on new Maths ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 4, 2020, 10:32am UTC](https://community.glideapps.com/t/vlookup/9973/17 "2020-06-04T10:32:16Z")
We can’t have a look at your Editor, only you can view it. Can we have some screenshots and a brief, clear point of what you’re trying to achieve after inputting the original number. I want to see a clear logic and flow of the data, then I can help. ---
**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:** [June 4, 2020, 11:00am UTC](https://community.glideapps.com/t/vlookup/9973/18 "2020-06-04T11:00:32Z")
Hi I have set the Google sheet to share - It is a modified version on the one that you allowed me to share so I cant understand why you cant see the Editor as I was able to see yours… Thanks ---
**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:** [June 4, 2020, 11:04am UTC](https://community.glideapps.com/t/vlookup/9973/19 "2020-06-04T11:04:38Z")
![Screenshot 2020-06-04 at 13.01.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/942236613013a6626a3ff2cba618fc90ff8ee431.png) ![Screenshot 2020-06-04 at 13.01.30](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1aa4ece041400753eddc727288c318d471c625ec.png) ![Screenshot 2020-06-04 at 13.01.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d1ce4b58200721d7b6d3e39ce77158847c2cb238.png) ![Screenshot 2020-06-04 at 13.02.02](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/08c8749f902f79543254cc88336149a9c9659243.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 4, 2020, 11:05am UTC](https://community.glideapps.com/t/vlookup/9973/20 "2020-06-04T11:05:16Z")
When I said the Editor I mean the Glide editor, not the Spreadsheet. Thank you for sharing the screenshots. [Next page](https://community.glideapps.com/t/vlookup/9973.md?page=2)