How to apply multiple filters on the product list?
Hi, could you please help us in providing more details about your requirement? What filters are required? Where are you storing data to be fetched in these filters, etc.?
I have a SKU List page wherein SKUs are listed based on Super Category & Brand (were selected on previous pages). On I want to slice and deice my SKU List based on the Category->Segment and Sub-Segment.
Please note - All these parameters are in single sheet.
Let me know in case of more details. Happy to share.
In this case, you can use multiple filters in LOOKUP() function. For instance, if you want to search a SKUs based on Super Category, Brand and Category/Segment/Sub-Segment, then you can use AND() in LOOKUP() as shown below -
Where, supercategorycontrol/brandscontrol/categorycontrol/segmentcontrol/subgmentcontrol are respective controls to select values for Super Category/Brands/Category and so on.