Need to convert an Excel formula to a Google Sheet formula

Question

I created a formula that works in Excel but cannot get it to work in Google Sheets. Can someone please help?

=IF(ISNUMBER(SEARCH("amp",$A2)), "AMP", IF(ISNUMBER(SEARCH("feed",$A2)), "Feed", "Other"))

Thanks!

Answer 1

try perhaps:

=IF(ISNUMBER(SEARCH("amp";  A2)); "AMP", 
 IF(ISNUMBER(SEARCH("feed"; A2)); "Feed"; "Other"))