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")

 

[MNexcel]

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

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

@RoryA - is there anyway to use that formula and add multiple of the same formula in there?

Essentially I am creating a budget sheet, and want if it contains "Holiday" to return "Gas Station", so they're reading of what is contained in column C to report back a subcategory of income/expense. Let me know if you need more information.