# How To Run a sheets function on a lookup result

**URL:** <https://community.glideapps.com/t/how-to-run-a-sheets-function-on-a-lookup-result/12017>\
**Category:** Ask for Help\
**Created:** [July 5, 2020, 5:38pm UTC](https://community.glideapps.com/t/how-to-run-a-sheets-function-on-a-lookup-result/12017 "2020-07-05T17:38:44Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [July 5, 2020, 5:38pm UTC](https://community.glideapps.com/t/how-to-run-a-sheets-function-on-a-lookup-result/12017/1 "2020-07-05T17:38:44Z")

</div>

Hello,

I have a lookup result in glide.  
I want to create a new column(for display in the app) where each cell is the result of a sheets function with the lookup result as parameter. I mean :

> cell = sheetsFunction(lookupResult)

possible?

---

<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:** [July 5, 2020, 10:14pm UTC](https://community.glideapps.com/t/how-to-run-a-sheets-function-on-a-lookup-result/12017/2 "2020-07-05T22:14:27Z")

</div>

Do you have that lookup result in your sheets? You have to have it there to be able to apply sheet functions. Can you describe more about your use case?

---

<div class="post-metadata">

**Author:** ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)\
**Post date:** [July 6, 2020, 2:39pm UTC](https://community.glideapps.com/t/how-to-run-a-sheets-function-on-a-lookup-result/12017/3 "2020-07-06T14:39:28Z")

</div>

I don’t.  
That’s why I’m asking a question here.  
I have a function in sheets which converts time zones.  
I wanted to use it

---

<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:** [July 6, 2020, 2:40pm UTC](https://community.glideapps.com/t/how-to-run-a-sheets-function-on-a-lookup-result/12017/4 "2020-07-06T14:40:51Z")

</div>

Then you have to make a VLOOKUP function yourself in the sheet to be able to use Sheets functions with it.