# Merging two values to a lookup
**URL:** https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891
**Category:** Ask for Help
**Created:** [September 16, 2020, 3:01pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891 "2020-09-16T15:01:31Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 3:01pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/1 "2020-09-16T15:01:31Z")
Hello everyone,
I need to take 2 values among 4 columns and merge them or find another way to make a single value from them, and relate to another column. Then, I need to Lookup values based on this relation, but is not working how I minded. My idea, was to make a template and replace the variables, so with this merged value, my relation could link the columns that I want.
Unfortunately, the IF THEN ELSE don’t have a “AND” possibility, otherwise I think this could solve this.
Anyone can help me on this one?
TASK:
Relate the 2 values of this 4 columns with one another column with merged possibles results, then lookup for other values on that row.
This is what I’ve tried:
TEMPLATE \> REL \> LOOKUP
I want to relate with this column and lookup their respective values
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 16, 2020, 4:53pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/2 "2020-09-16T16:53:40Z")
Why do you need that “Hip Final” column may I ask?
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 5:03pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/3 "2020-09-16T17:03:44Z")
I was trying to create a relation column, so I made this “hip final” to match the original column.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 16, 2020, 5:19pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/4 "2020-09-16T17:19:55Z")
Why don’t you use the template column on the left of that?
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 5:23pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/5 "2020-09-16T17:23:39Z")
I don’t know how to make a template column a relation column too, cause this template is merging my variables, then I need to take this merged value and relate to other column, i don’t know how to do with just one template column
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 16, 2020, 5:24pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/6 "2020-09-16T17:24:33Z")
Can you try using that template column as the source for your relation to see if anything
comes up?
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 5:35pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/7 "2020-09-16T17:35:12Z")
Nothing happened, unfortunately. I guess this issue is somehow related to the template format, when one value becomes empty, this should interfere with the relation match, just wondering. I’m a beginner.
Using template source:
Template format:
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 5:42pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/8 "2020-09-16T17:42:48Z")
I’ve made this example with simple letters to show the whole idea:
I have 4 columns with possible results, the user must pick 2 options, so two columns will become empty and two will be filled:
Then, depending on this combination I will use a value
At Glide:
 
The issue is when I make the relation columns, It’s not matching at all
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 7:23pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/9 "2020-09-16T19:23:26Z")
@Robert_Petitto Could you give me an idea on how to solve this?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [September 16, 2020, 10:10pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/10 "2020-09-16T22:10:10Z")
So are you using the merged value column to relate back to the hypothesis column? Are you sure you do not accidentally have any spaces in there?
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 16, 2020, 10:38pm UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/11 "2020-09-16T22:38:49Z")
I gonna check it
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 17, 2020, 4:21am UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/12 "2020-09-17T04:21:22Z")
There’s no spaces at all. I believe there’s a bug or is a clever way to do this that I don’t figure out. ☹
Thanks for trying to help
---
### Author:  [@Bruno\_Sia](https://community.glideapps.com/u/Bruno_Sia)
#### Post date: [September 17, 2020, 4:37am UTC](https://community.glideapps.com/t/merging-two-values-to-a-lookup/15891/13 "2020-09-17T04:37:04Z")
Finally got it. I changed the name of cells to a simple letter and now it worked. Thanks anyway in be interested. So, the template can merge values to a lookup, probably an “and” statement inside I-T-E, would save a bunch of time.