# Comparing and filtering from multiple sheets

**URL:** <https://community.glideapps.com/t/comparing-and-filtering-from-multiple-sheets/12736>\
**Category:** Ask for Help\
**Created:** [July 18, 2020, 4:10pm UTC](https://community.glideapps.com/t/comparing-and-filtering-from-multiple-sheets/12736 "2020-07-18T16:10:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)\
**Post date:** [July 18, 2020, 4:10pm UTC](https://community.glideapps.com/t/comparing-and-filtering-from-multiple-sheets/12736/1 "2020-07-18T16:10:41Z")

</div>

So i have multiple sheets containing Stores, Products, Offers… Currently they are unrelated. What i want is to reference data in sheets with each other. For Example, i have a IsEnabled flag in each sheet. So if any Store is disabled it should also be then hidden from Products, Offers.  
I have coupon code in Coupons sheet so i should be able to fetch it for particular Store when i display detail screen of that Store from Stores list or in Offer’s or Deal’s section.

What will be best practice/mechanism to follow for this?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 18, 2020, 7:11pm UTC](https://community.glideapps.com/t/comparing-and-filtering-from-multiple-sheets/12736/2 "2020-07-18T19:11:14Z")

</div>

Have you explored setting up relation and lookup columns? For example, I assume you have a store name in you products sheet. There you can create a single relation to link the store name in products to the store name in Stores. Then you can create a lookup column that brings the isEnabled flag into the products sheet. There you can use it for filtering and visibility wherever you display products in your app.

---

<div class="post-metadata">

**Author:** ![Coupons\_Deal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/coupons_deal/32/9734_2.png) [@Coupons\_Deal](https://community.glideapps.com/u/Coupons_Deal)\
**Post date:** [July 19, 2020, 9:50pm UTC](https://community.glideapps.com/t/comparing-and-filtering-from-multiple-sheets/12736/3 "2020-07-19T21:50:33Z")

</div>

I think this solves my purpose 👍 but will playaround with this for sometime to be sure it fits my requirement.