# Convert Look up to text

**URL:** https://community.glideapps.com/t/convert-look-up-to-text/71130
**Category:** Ask for Help
**Created:** [February 25, 2024, 10:54am UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130 "2024-02-25T10:54:02Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)
#### Post date: [February 25, 2024, 10:54am UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/1 "2024-02-25T10:54:02Z")

</div>

Hi everybody,

I would like to convert a Look up column that is coming from a match multiple relation to a text. Is that possible? Any tips will be apreciate.

Many thanks in advanced.

Albert Puig

---

<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, 10:59am UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/2 "2024-02-25T10:59:12Z")

</div>

Use a Joined List column.

---

<div class="post-metadata">

### Author: ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)
#### Post date: [February 25, 2024, 5:05pm UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/3 "2024-02-25T17:05:05Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b12afb71cc94c5afd10ca7ed6585d494bfebad98.jpeg)  
Hi Darren,

Thanks for your answer, I tried but the Look up comlumn I am looking for is not showing. May be because the relation is a match multiple but I can’t avoid this…

Here an image…

Thanks again for your help.

Albert Puig

---

<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, 5:24pm UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/4 "2024-02-25T17:24:59Z")

</div>

Sorry, what I meant is a joined list through the relation. Instead of the lookup.

---

<div class="post-metadata">

### Author: ![lame](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@lame](https://community.glideapps.com/u/lame)
#### Post date: [February 25, 2024, 7:02pm UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/5 "2024-02-25T19:02:06Z")

</div>

use the ‘Join’ function.  
=Join(", ", LookupColumn)  
Replace “LookupColumn” with the actual name of your Look up column. Copy and paste this formula into the column where you want the text, and it should work for you!  
Regards,  
Lame

---

<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: [February 26, 2024, 12:04am UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/6 "2024-02-26T00:04:55Z")

</div>

Isn’t this a Google Sheets solution? The Joined List column does the same thing and is built as a computed column in Glide.

---

<div class="post-metadata">

### Author: ![Albert\_Puig](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/albert_puig/32/84707_2.png) [@Albert\_Puig](https://community.glideapps.com/u/Albert_Puig)
#### Post date: [February 26, 2024, 1:17pm UTC](https://community.glideapps.com/t/convert-look-up-to-text/71130/7 "2024-02-26T13:17:00Z")

</div>

OK, understood. It worked fine.

Thanks!

Albert Puig