I'm trying to write an If / Then statement that will check to see if a particular word is contained in a cell. The Cell could have several words and I'm only looking for one.
I've tried using the *(wildcard) but it doesn't give me the correct answer.
=IF(B2 = *"PB"*, "PB", "Other"
The above formula always gives an "Other" answer.