Filter and contains

Mario36

Hi All,

I am looking to find the restaurants in Bangalore where the dishes 'Kebab' or 'Chilly Chicken' are available. I have used the below formula on the Custom Filter tool but it does give me restaurant names apart from Bangalore too. Grateful if anyone could help. The excel file and screenshot is attached.

[Location] = "Bangalore" AND
Contains([Chicken Dishes],"Kebab") OR Contains([Chicken Dishes],"Chilly chicken")

Food Menu.xlsx

atcodedog05

Hi @Mario36 

If you can formula like below it should work.

[Location] = "Bangalore" AND
(Contains([Chicken Dishes],"Kebab") OR Contains([Chicken Dishes],"Chilly chicken"))

I am warping up the or condition with brackets.

Hope this helps 🙂