# Display Lookup Column Data in Google Sheet

**URL:** <https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101>\
**Category:** Ask for Help\
**Created:** [February 19, 2021, 5:15pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101 "2021-02-19T17:15:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [February 19, 2021, 5:15pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101/1 "2021-02-19T17:15:16Z")

</div>

Hi,

Is there a way I can display a Lookup Column’s data inside of a Google Sheet? I need to use that data in the sheet for a formula. Lookups do not display in the Google Sheet.

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 19, 2021, 5:41pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101/2 "2021-02-19T17:41:34Z")

</div>

No. That’s not possible. Computed columns (such as Lookups) are calculated on each users device.  
If you need the data in the Google sheet, then you’ll have to replicate the Lookup there - probably using a VLOOKUP() function.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [February 19, 2021, 5:57pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101/3 "2021-02-19T17:57:10Z")

</div>

Oh Ok I will try this. Thanks!

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [February 19, 2021, 6:26pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101/4 "2021-02-19T18:26:50Z")

</div>

How can I create a lookup if I can’t see that data in Google Sheets?

---

<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 19, 2021, 7:13pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101/5 "2021-02-19T19:13:51Z")

</div>

Well, you can only work with the data you have in your Google sheets.  
Your Glide Lookup will be based on a relation, that joins two sheets/tables using a common key.  
Do both of those sheets, and the common keys, exist in your Google sheets?  
If yes, then you should be able to replicate your Glide Lookup using a VLOOKUP() function.  
If no, then you might need to work backwards a little bit.  
Without seeing your data, it’s a little difficult to say.

You mentioned that you need this in order to feed into a Google sheet formula. Have you explored the option of replicating that formula in Glide?

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [February 19, 2021, 7:50pm UTC](https://community.glideapps.com/t/display-lookup-column-data-in-google-sheet/23101/6 "2021-02-19T19:50:40Z")

</div>

Ah got it! Yes, both ‘common keys’ are in the google sheet. I had a vlookup formula in there, but had no idea what it meant, now from what your’re saying understand what data its trying to pull. Thank you!