I am currently using Excel to compare a number of different membership options for a client. The are lined up column by column with a selection of amenities down the first column. In each column after the first is a membership option and a tick as to whether or not each amenity is present in each specific membership. What I am hoping to be able to do is search for specific amenities that the client wants, and present him with the options that have these. For example if I were able to type in "swimming pool" that would be able to eliminate all the memberships without a swimming pool. Any help would be massively appreciated.

Cheers.