Excel筛选手机号码运营商公式（筛选移动联通电信）

需求背景：自动判断手机中导出的Excel联系人的运营商

解决方案：

一、确保“手机号码”列（A列）为文本

二、新建“手机号码首三位”列（B列，本列设置为数字格式），公式：=LEFT(A1,3)*1

三、新建“运营商”列（C列），公式：

=LOOKUP(B1,{130,131,132,133,134,135,136,137,138,139,150,151,152,153,155,156,157,158,159,180,185,186,187,188,189},{"联通","联通","联通","电信","移动","移动","移动","移动","移动","移动","移动","移动","联通","电信","联通","联通","移动","移动","移动","电信","联通","联通","移动","移动","电信"})
解决方案（简化版）：
一、确保“手机号码”列（A列）为文本
二、新建“运营商”列（B列），公式：
=LOOKUP(LEFT(B2,3)*1,{130,131,132,133,134,135,136,137,138,139,150,151,152,153,155,156,157,158,159,180,185,186,187,188,189},{"联通","联通","联通","电信","移动","移动","移动","移动","移动","移动","移动","移动","联通","电信","联通","联通","移动","移动","移动","电信","联通","联通","移动","移动","电信"})
[via]