# Vlookup

**URL:** <https://community.glideapps.com/t/vlookup/9973>\
**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:** 6\
**Page:** 2

<div class="post-metadata">

**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:06am UTC](https://community.glideapps.com/t/vlookup/9973/21 "2020-06-04T11:06:54Z")

</div>

Can you have a write up about the data flow from when the user enters the number to your expected end result. It would be nice to have all the logics like this.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3798768b0964cd21c91c1889a010c8b197603506.png)

---

<div class="post-metadata">

**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:24am UTC](https://community.glideapps.com/t/vlookup/9973/22 "2020-06-04T11:24:11Z")

</div>

Sorry But I thought that if this is checked you can make a copy - as I did with yours…

![Screenshot 2020-06-04 at 13.07.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/544df570bcc92155e9edc198e2c21a8478f92e91.png)

---

<div class="post-metadata">

**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:26am UTC](https://community.glideapps.com/t/vlookup/9973/23 "2020-06-04T11:26:38Z")

</div>

Oh sorry I completely missed the “Copy this app” button. It’s a been a long day for me haha. Let me have a look later tonight.

---

<div class="post-metadata">

**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:27am UTC](https://community.glideapps.com/t/vlookup/9973/24 "2020-06-04T11:27:15Z")

</div>

You are very kind !  
Thanks

---

<div class="post-metadata">

**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 5, 2020, 1:50am UTC](https://community.glideapps.com/t/vlookup/9973/25 "2020-06-05T01:50:43Z")

</div>

Changes I would made to the app:

- You stored an image inside a text column, I would delete all those columns and used a “From URL” settings for your image. Since it will always be there, no need to store an additional column in the sheets.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ea5539efd9ce57625030987f3c3ac0dd8991e976.png)

- For the fee calculation, you don’t need to have to columns to generate the final fee. The problem there was the fixed 6600 as it’s not the same scale as the other numbers. The right setup would be this and it will work.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e8166661be875848140314d44ea5b8132ce4b1b5.png)

I thought about using a sign function to just have one math column but it doesn’t work with what we currently have. I see you have the same setup for other tabs so hopefully this helps.

---

<div class="post-metadata">

**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 5, 2020, 5:52am UTC](https://community.glideapps.com/t/vlookup/9973/26 "2020-06-05T05:52:58Z")

</div>

Thank you very much  
I will do some reworking this morning.  
Keep safe.  
Mike

[Previous page](https://community.glideapps.com/t/vlookup/9973.md?page=1)