Hi Team!
Please see the screenshot. I can't attach the entire excel file as it contains other sensitive data. (Sorry for inconvenience).
This is what I am trying to do:
If column E = the text "Bird Specialist", "Bird Specialist + Certified Trainer", "Certified Trainer", "Crew" or "Cross-Trained" then the cell in column G will populate with "CM" (please see column J for this reference".
I have other criteria for column E (please see column J for reference):
General Manager in Training to appear in column G as GMIT
Shift Manager in Training to appear in column G as SMIT
Operations Manager in Training to appear in column G as OMIT
and there are more, but I think you get the picture.
I tried using IF and IFS but I can't quite work it out. Can I have some help?
Bookmarks