I have a column of cells that has data in it (in the form of sentences). In column B, I would like it to say "Added Lesson" if there is text in column A saying "Added Lesson". If there is not text that says "Added Lesson" it should say "Other".
THanks!
Just to be clear.. they are whole sentences. Somewhere in the sentence it says "Added Lesson".