=VLOOKUP(--MID(A1,7,2),{52,"汽修";53,"电子商务";54,"数控"},2,)
=LOOKUP(--MID(A1,7,2),{52,"汽修";53,"电子商务";54,"数控"})
=LOOKUP(MID(A1,7,2),{"52","汽修";"53","电子商务";"54","数控"})
=LOOKUP(MID(A1,7,2),{"52","53","54"},{"汽修","电子商务","数控"})
=LOOKUP(--MID(A1,7,2),{52,53,54},{"汽修","电子商务","数控"})
=IF(MID(A1,7,2)="52","汽修",IF(MID(A1,7,2)="53","电子商务",IF(MID(A1,7,2)="54","数控","")))