帮忙改善一下公式，把匹配内容改为搜索区域内的内容

凌云漂流瓶2014

=IF(OR([@工序]={"电流测试位","装配采集(3)"}),"装配段",IF(OR([@工序]={"CCT传感器校准位","IMU传感器测试位","LCM色温测试位","OIS测试位","OIS三测试位","SAR功能测试位","SIM卡自动测试位","辐射杂散测试位","激光测试位","流转自检测试位","马达校准测试位","耦合非信令2","耦合非信令3","拍照辅助功能测试位","全自动MMI2测试位","全自动MMI3测试位","全自动黑白板测试位一","全自动解析力测试位一","双摄融合测试位二","音频测试位","音频二测试位","有线充电自动测试位","整机LCM测试位","整机气密性测试","整机无线充电测试位","自动拍照七测试位","自动拍照十一测试位","自动拍照五测试位"}),"测试段",IF(OR([@工序]={"返工前处理位","MMI辅助测试位","对比位","订单状态执行工位","IMEI打码位","包装称重位","返工检查工位","功能测试位1","成品装箱"}),"包装段",IF(OR([@工序]={"老化前测试位","老化结束工位"}),"老化房",""))))

夜雨无声1949

先看看发帖注意
https://club.excelhome.net/threa ... tml?_dsign=bc98cbe9

ww87725244

你这没有附件，又贴了一段老长老长的函数，都看眼花了

凌云漂流瓶2014

夜雨无声1949 发表于 2024-5-29 19:37
先看看发帖注意
https://club.excelhome.net/thread-1461222-1-1.html?_dsign=bc98cbe9

已上传图片及需求

夜雨无声1949

凌云漂流瓶2014 发表于 2024-5-29 22:05
已上传图片及需求

你的要求也只截取了一半啊，话说你上个附件老师看见了不是很麻烦老师们就会帮忙了，