# Relate/lookup value from multiple tables

**URL:** <https://community.glideapps.com/t/relate-lookup-value-from-multiple-tables/68080>\
**Category:** Ask for Help\
**Created:** [November 23, 2023, 11:30pm UTC](https://community.glideapps.com/t/relate-lookup-value-from-multiple-tables/68080 "2023-11-23T23:30:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kurt\_Penberth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kurt_penberth/32/66463_2.png) [@Kurt\_Penberth](https://community.glideapps.com/u/Kurt_Penberth)\
**Post date:** [November 23, 2023, 11:30pm UTC](https://community.glideapps.com/t/relate-lookup-value-from-multiple-tables/68080/1 "2023-11-23T23:30:53Z")

</div>

I have a jobs table with an order number column.

That order number will match an order number in one of 5 google sheets. Each sheet is different, as it contains responses from 5 different forms.

How can I relate the order number in the jobs table, with the order number in one of the other sheets, without knowing which sheet it’s in?

The only thing I need to know is if that order number is present in one of the sheets, so I can show that step as complete. I don’t need to bring any values across to the jobs table.

TIA

---

<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:** [November 24, 2023, 2:25am UTC](https://community.glideapps.com/t/relate-lookup-value-from-multiple-tables/68080/2 "2023-11-24T02:25:19Z")

</div>

You would need to create 5 separate relations, and then use an if-then-else column that returns true if any one of the 5 is not empty.