Return a certain value if partial text is found on another cell
Hello guys, I've been struggling to find a good formula for this case. Basically I have one column with different text (Band 5 RN, Band 6 RN and Band 2 HCA) and I want to create a new column that returns "Nursing" when the cell contains the text RN and to return "Other" when it doesn't.
Anyone with a correct formula? I've tried IF(CONTAINS) without success. Thanks!
Help Article Resources
Check out the Formula Handbook template!