Prioritize a condition or overriding other true conditions

Hello everyone, I have a specific requirement for my formula to function correctly.

I need to prioritize the condition where if L2 equals 96662-100, it should return "96662-100", overriding any other true conditions or nested IF statements.

Despite placing this condition first, I'm encountering an issue where cell M2 doesn't retain the correct result.

Could someone help clarify why this might be happening?

Thanks a lot.

Please Login or Register  to view this content.

otherwise you are saying = 96662-100=96562