Can I make a rule that if a phrase in A2 contains a specific word, then B2 must be a specific word? I.e.,
The vlookup feature allows me to say if A2 is dog, B2 is canine. I want to write a sentence like "the dog jumped" in A2, and because it contains the word dog, B2 automatically says "canine."
Is this possible?
Bookmarks