Flexible Text Search with either VLookup or Index Match

I am looking to put in a formula to help return the given campaign name based on if certain keywords are found in the post text. I need the formula to do the following...

1) From 'Tab 2' image - look at post text in column C and for each row identify the respective campaign from the 'Tab 1' image
2) If the post text meets any of the text descriptors (rows 3 through 23) on 'Tab 1' image, mark it as the respective campaign from row 2 in 'Tab 1' image
3) The proper campaign would then be identified in column D in 'Tab 2' image

*The keywords will be mutually exclusive when identifying the campaign
** I would need this to be a flexible formula, as in campaigns and their respective keywords will be added pretty frequently to the table but won't go below the 23rd row (so I don't want to do a long ='if(isnumber(search' formula each time)

For example, if the post text reads "Hope you #beourguest" in column C on 'Tab 2' image, the campaign Beauty and The Beast should be returned in column D on the 'Tab 2' sheet


Hope this helps and thank you!

Tab 2.PNGTab 1.PNG

Please see attached.

Thank you!

Works great! Thank you.

Following up here. I'm noticing that if the formula finds multiple keywords under the same campaign, it will return 'no match' rather than the campaign name.

For example with the Holiday campaign, if the text has both 'holiday' and 'holidone' in it, it will return 'no match'. Wondering if there is a quick fix here to allow it to still return back the campaign "Holiday" in that scenario.

Works like a charm, thanks again!