I'd be trying to use something like:

=IF(SEARCH("Auto",A1),1,0)

The problem is that SEARCH returns #VALUE if the search string isn't found

Neil.