if cell contains string then make cell next to it equals "X"
 

Hi all,

I have a work sheet with loads of urls in it like this one:
www.hot-tub-uk.co.uk/links/hot-tubs-&-spas.htm

I need a formula that will put an x in the cell next to it if the url
contains any of the following words:
link, links, resource, resources

Can any one help

Many thanks

Alex Kemsley

if cell contains string then make cell next to it equals "X"
 

=IF(ISNUMBER(SEARCH({"link","resource"},A21)),"x", "")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Hi all,

I have a work sheet with loads of urls in it like this one:
www.hot-tub-uk.co.uk/links/hot-tubs-&-spas.htm

I need a formula that will put an x in the cell next to it if the url
contains any of the following words:
link, links, resource, resources

Can any one help

Many thanks

Alex Kemsley