If I put "East" Under the shops in my Output sheet, then all the rows which contains "East' in the Reference sheet should get pulled up. The problem is that Shops column contains input like this "East, West and North", "East and South". It would have been easier for me to extract data through...