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.