Using ISERROR with OR
Posted on 2013-01-31
I have a cell that can have the value "MGR" or "MANAGER" in it along with other information.
MGR and MANAGER may be at the beginning of the field or in the middle or at the end.
You might have "MGR OF LOGISTICS" or "MANAGER OF LOGISTICS" or "KITCHEN MANAGER".
If you have MGR or MANAGER, I want it to come back with "MGR".
If it is NOT MGR or MANAGER, I don't want an error, but a blank.