Spreadsheet: 88929d1288731932-find-any-one-of-a-list-of-terms-in-a-single-string-of-terms-string-search-test
Sheet: Sheet1

Url | logic | Desired results | Guru formula here |  | Site
http://www.google.com/search?client=safari&rls=en&q=sports+authority&ie=UTF-8&oe=UTF-8 | if a2 contains any of the strings in e2:e8 then true | True |  |  | search.yahoo
http://www.google.com/search?q=sports+authority&ie=UTF-8&oe=UTF-8&hl=en&client=safari | " | True |  |  | bing.com/search
http://www.google.com/search?q=sports+authority&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a | " | True |  |  | google.com/search
http://www.bing.com/search?q=sports+authority&form=MSNH14&qs=AS | " | True |  |  | google.com/m?
http://slickdeals.net/?sid=259&u2=http://www.sportsauthority.com/home/index.jsp | " | False |  |  | google.com/url
http://search.yahoo.com/search?p=sports+authority&toggle=1&cop=mss&ei=UTF-8&fr=yfp-t-701 | " | True |  |  | maps.google
http://www.bing.com/search?q=sports+authority&src=IE-SearchBox&FORM=IE8SRC | " | True |  |  | google.ca/search
http://www.google.com/search?q=sports+authority&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1 | " | True
http://www.google.com/ | " | True
http://www.google.com/search?client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&channel=s&hl=en&source=hp&q=sports+authority&btnG=Google+Search | " | True
http://promocode-2010.com/promo-code/Sports_Authority/ | " | False
http://slickdeals.net/?sid=259&u2=http://www.sportsauthority.com/ | " | False
http://www.couponalbum.com/coupons/sports-authority.htm | " | False
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=sports+authority | " | True
http://www.bing.com/search?q=sports+authority&src=IE-SearchBox&Form=IE8SRC | " | True
http://www.google.com/search?q=sports+authority&sourceid=ie7&rls=com.microsoft:en-us:IE-SearchBox&ie=&oe= | " | True
http://tsa.imageg.net/graphics/media/concept/ua_fb2010_main.swf | " | False
http://us.mg2.mail.yahoo.com/dc/blank.html?bn=504.5&.intl=us&.lang=en-US | " | False
http://www.bing.com/search?q=sports+authority&src=IE-SearchBox | " | True
http://www.bing.com/search?q=sports+authority&form=MSNH14&qs=n | " | True
[NAME] | " | False
http://www.google.com/search?q=sports+authority&rls=com.microsoft:*&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1 | " | True
http://search.comcast.net/?cat=Web&con=homepage&q=sports+authority | " | False
http://www.google.com/search?q=sports+authority&rls=com.microsoft:en-us:IE-SearchBox&ie=UTF-8&oe=UTF-8&sourceid=ie7&rlz=1I7GGLL_en | " | True
http://us.mg4.mail.yahoo.com/dc/blank.html?bn=504.5&.intl=us&.lang=en-US | " | False
http://us.mg1.mail.yahoo.com/dc/blank.html?bn=504.5&.intl=us&.lang=en-US | " | False
http://oas.imageg.net/O/a/Creatives/TSA_Nike_ConceptShop/TSA_NIKE_landing_Oct.swf | " | False
http://www.google.com/search?q=sports+authority&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8 | " | True
http://www.google.com/search?aq=f&sourceid=chrome&ie=UTF-8&q=sports+authority | " | True
http://sportsauthority.shoplocal.com/sportsauthority/default.aspx?action=nuep& | " | False
http://search.aol.com/aol/search?s_it=comsearch40t&q=sports+authority | " | False
http://itsabove.com/specials/free-shipping-sports/ | " | False
http://search.aol.com/aol/search?query=sports+authority&s_it=keyword_rollover | " | False
https://mail.google.com/mail/?ui=2&view=bsp&ver=ohhl4rw8mbn4 | " | True
http://mail.aol.com/32823-111/aol-1/en-us/Suite.aspx | " | False
http://www.sportmart.com/ | " | False
http://dealnews.com/ | " | False
http://tsa.imageg.net/cms_widgets/34/22/342242_assets/hp_sanfran_102410.swf | " | False
http://www.bing.com/search?q=sports+authority&form=DLCDF8&pc=MDDC&src=IE-SearchBox | " | True
 |  | False