help with formula in Google Sheets

[MNexcel]

I am trying to write a formula where if the data in cell D2 contains any specific partial words, that it'll return what category it's in. Currently I have "yay" or "nay", but that'll change. Below is the current formula I am using.

=IF(REGEXMATCH(D4,"*VEN*"),"YAY","NAY")

 

[MNexcel]

bump

 

[RoryA]

That isn't a regular expressions pattern. For that, all you need is search:

=IF(ISNUMBER(SEARCH("VEN",D4)),"YAY","NAY")