Google sheets - search a cell for multiple partial words and return different value for each partial word

Question

I am trying to put a formula together that will look at a cell and return a value based on a partial word, but to do it with multiple criteria. For example:

If A1 has the following in it:
Type of session: Private

If A2 has:
Type of session: Group

In another cell I want to then search A1 for private and if it finds it return something, like for example 1. But at the same time, search A1 for group and if it finds it, return 2 for example. If it finds none of my criteria, it can return 0 for example.

Answer 1

Use regexmatch() and Boolean arithmetic, like this:

=regexmatch(A1, "(?i)Private") + 2 * regexmatch(A1, "(?i)Group")