公式内容:
=IF(LOOKUP(--LEFT(0&D2,4),{0,130,140,147,148,150,154,155,160,180,181,182,183,185,186,187,188,189,190},{0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0,1,0}),LOOKUP(--LEFT(D2,3),{130,133,134,153,155,157,180,182,185,187,189},{"联通","电信","移动","电信","联通","移动","电信","移动","联通","移动","电信"}),"--")