# How to do a lookup when concatenating text with template column
**URL:** https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006
**Category:** Ask for Help
**Created:** [May 20, 2021, 6:16am UTC](https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006 "2021-05-20T06:16:43Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@JHor](https://community.glideapps.com/u/JHor)
#### Post date: [May 20, 2021, 6:16am UTC](https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006/1 "2021-05-20T06:16:43Z")
Hi,
I am creating a form where there are multiple options people can select. At the end, the combination of selections will show a different photo for each combination. As they select items from a choice option in the app, each selection is entered into four different columns in a glide table (am testing to see if I can build this outside of g sheets). I have another column which is a template column concatenating the text into a single entry. This concatenated text is used in order to use a single lookup to link the concatenated text to the URL for the image.
As an example:
Options 1,3 & 5 are selected from three different choice options. In the glide table, the answers are being recorded in three separate columns. The template column concatenates this to “135”. In a separate table, 135 is listed in the “Name” column and in the “Photo” column there is the URL for the photo which should appear with a lookup for “135”.
The issue I have is that the relation is not working when trying to connect the concatenated text to the “Name” column. This means the lookup doesn’t work to bring the photo URL across.
Can anyone help with this set up?
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [May 20, 2021, 6:22am UTC](https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006/2 "2021-05-20T06:22:44Z")
Hi,
Not sure but Is the Name/photo table got “concatenated” column as well ?
What i understand is you have two tables.
1st you got the user and its 3 choices
2nd you got name and photos
am i right?
---
### Author:  [@JHor](https://community.glideapps.com/u/JHor)
#### Post date: [May 20, 2021, 6:27am UTC](https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006/3 "2021-05-20T06:27:52Z")
I have just managed to make it work using a combination of “If-then-else” and “Split text”. Not particularly elegant but does the job!
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [May 20, 2021, 6:32am UTC](https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006/4 "2021-05-20T06:32:40Z")
Glad to hear that!
---
### Author:  [@Michael\_Kagan](https://community.glideapps.com/u/Michael_Kagan)
#### Post date: [February 20, 2022, 4:18am UTC](https://community.glideapps.com/t/how-to-do-a-lookup-when-concatenating-text-with-template-column/27006/5 "2022-02-20T04:18:02Z")
have you seen @Robert_Petitto “[Transpose Data Columns into an Inline List with the MIRACLE METHOD](https://youtu.be/t-sh_Q3WbQc)”