Formula with multiple conditions

Hello!! I am not tech savvy and need help creating an Excel formula to lighten my workload. Here is what I want to do:  whatever the beginning ticket number sequence is in B2 would populate C2 as cor...