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?