Finding specific words within URL queries

[joncatalan]

I have a spreadsheet of all the pages on the website, or a total of ~12,000.

I am preparing documentation on condensing content of the same topic.

I'd like to search within a query and output a simple TRUE or FALSE depending on whether the words "best", "top", and "strain" are in the URL.

I've tried pairing the ISNUMBER and SEARCH functions, but it doesn't seem to work unless the words are clearly separate in the cells.

[CK76]

I'd recommend uploading sample of your data (about 20 or so), with few examples of your expected results (manually entered).

This will help us in giving you solutions that will best fit your need.

To attach workbook, use "Go Advanced" button, follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.