# How can I use lookups in a glide app?

**URL:** <https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453>\
**Category:** Ask for Help\
**Created:** [September 20, 2019, 7:14pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453 "2019-09-20T19:14:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![benclark06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benclark06/32/224_2.png) [@benclark06](https://community.glideapps.com/u/benclark06)\
**Post date:** [September 20, 2019, 7:14pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453/1 "2019-09-20T19:14:40Z")

</div>

Hey, i’m trying to use a lookup in my app so when someone adds an entry, their email is saved, then a lookup function looks up their name and then displays their name on the entry. The problem is that when I try to do this currently, whenever i add a new one it just adds it to the bottom without copying the function. Is there a way to do this? I know `arrayformula` is a thing but when I try to do it with my current formula, it doesn’t work.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 20, 2019, 7:20pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453/2 "2019-09-20T19:20:34Z")

</div>

You can use the `VLOOKUP` formula in your sheet for this.

Here is how you make it continue to work as new columns are added: [https://docs.glideapps.com/all/guides/intermediate-techniques/calculating-columns](https://docs.glideapps.com/all/guides/intermediate-techniques/calculating-columns)

---

<div class="post-metadata">

**Author:** ![benclark06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benclark06/32/224_2.png) [@benclark06](https://community.glideapps.com/u/benclark06)\
**Post date:** [September 20, 2019, 8:10pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453/3 "2019-09-20T20:10:02Z")

</div>

hi david,  
i’ve tried using `vlookup` with `arrayforumula`, however it’s not working properly, the formula i’m using is `=ArrayFormula(VLOOKUP(C2, Users!A2:C100006, 2, false))` but i only get this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/56524aeeb15f3aa9b7bda7cf957a113f7206b5d8.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 20, 2019, 8:41pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453/4 "2019-09-20T20:41:08Z")

</div>

Try changing C2 to C2:C  
You could also change your C100006 to C in your range.

---

<div class="post-metadata">

**Author:** ![benclark06](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benclark06/32/224_2.png) [@benclark06](https://community.glideapps.com/u/benclark06)\
**Post date:** [September 20, 2019, 8:43pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453/5 "2019-09-20T20:43:04Z")

</div>

> [@Jeff\_Hager](#):
>
> C100006

that works, thank you!!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 25, 2024, 3:21pm UTC](https://community.glideapps.com/t/how-can-i-use-lookups-in-a-glide-app/453/6 "2024-02-25T15:21:39Z")

</div>