Originally Posted by Jay07

=IF(H2="PM01","Emergency Works",IF(H2="PM02","Routine Works",IF(H2=PM03,"Pre Planned Maintenance")))

Column H can only contain either of PM01, PM02 or PM03. I want Column I to show the above values for each option.

It works for both PM01 & PM02 but I'm just getting #NAME? for PM03.



Thanks in advance.