“If isnumber” search / formula help needed

[John Louis]

Hello,
I would like to add if isnumber search to my tracker. In my tracker, column A2 each row list several different phrases (hold,confirm,auto,return,convert,etc) I want to have the formula look at each row in the column and find each row that contains “auto” and return “truck dispatch needed”. if “auto” isn’t found return a blank.
Thanks for your help

 

[blbat]

=IF(ISNUMBER(SEARCH("auto", $A2)), "truck dispatch needed", "")

 

[John Louis]

Thank you Blbat! That worked perfectly, apperciate your help. Have a great day.
Thanks John