Pretty much the same. You can join/concatenate with
Join() / Concatenate() (duh), and you can
RegexMatch() as well.
Although I don’t see any regex in there — you’re doing a substring match, so
Concatenate().Lower().Find("hr") != -1 could be a more performant idiom.
You cannot take words from column headers — you’ll have to put them on a separate table, then take from there to put into your matching formula(s).
If the number of terms to check in people’s profiles is not a constant set (i.e. not just those 6 terms), you should do it as separate rows instead of columns or build some other sort of automation.
On unrelated note, that’s quite a database of Ukrainian recruiters Almost a 1000 souls, omg. Almost a shame I don’t have any use for it, since I’m not looking for any workforce positions anymore.