# How to combine look ups from different locations?

**URL:** https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302
**Category:** Ask for Help
**Created:** [June 4, 2020, 8:03pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302 "2020-06-04T20:03:04Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Kevyn\_Levine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevyn_levine/32/7902_2.png) [@Kevyn\_Levine](https://community.glideapps.com/u/Kevyn_Levine)
#### Post date: [June 4, 2020, 8:03pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302/1 "2020-06-04T20:03:04Z")

</div>

Hi friends, me again…

I have one sheet with two lookup columns, each pulling images from a different sheet - is there a way to combine these two columns?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f50077ae90a059336a4eb7927aab29ef4faafd49.png)

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 4, 2020, 8:23pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302/2 "2020-06-04T20:23:30Z")

</div>

Would the end effect be a carousel of the two images? If so, you’d need to do your lookups in the spreadsheet, not the builder.

However, this does reinforce the need/feature request for being able to create array columns of similar column types manually/at will.

---

<div class="post-metadata">

### Author: ![Kevyn\_Levine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevyn_levine/32/7902_2.png) [@Kevyn\_Levine](https://community.glideapps.com/u/Kevyn_Levine)
#### Post date: [June 4, 2020, 8:24pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302/3 "2020-06-04T20:24:49Z")

</div>

Thanks for replying! The two columns would never conflict. Was hoping for a roll up -ish solution.

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 4, 2020, 8:27pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302/4 "2020-06-04T20:27:27Z")

</div>

Oh…I see what you mean. If one is empty you want the other? Yes. Create an if-then column. If the first lookup is empty then display the second, else display the first. Use this if-then column for your image component.

---

<div class="post-metadata">

### Author: ![Kevyn\_Levine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kevyn_levine/32/7902_2.png) [@Kevyn\_Levine](https://community.glideapps.com/u/Kevyn_Levine)
#### Post date: [June 4, 2020, 9:49pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302/5 "2020-06-04T21:49:05Z")

</div>

I like where you’re going with this…when I create the If Then Else column, when choosing the first condition it shows me relations and lookups, but once i select one, i can’t choose them as a “Then” option…any ideas why they can’t be selected?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/70cbc02ab48de48b2e32c786ff57dfbc482df8e4.png)

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 4, 2020, 11:25pm UTC](https://community.glideapps.com/t/how-to-combine-look-ups-from-different-locations/10302/6 "2020-06-04T23:25:45Z")

</div>

The original relation column from which you created the lookup needs to be a single relation, not multiple.