LOOKUP+MID 提取字母其中一组异样

月夜青衫

LOOKUP(MID(B4,1,2),{"NC","PC","TC","TV","AC","RF","WH","WM"},{"计算机","计算机","计算机","电视","空调","冰箱","热水器","洗衣机"})
AC此项为什么是斜体，且不被识别
或哪位大佬们，有别的办法
小弟新手感谢！






运营部.zip (52.23 KB, 下载次数: 11)

2021-11-10 09:01 上传

点击文件名下载附件
运营部.zip

跟随

=LOOKUP(1,0/(LEFT(B4,2)={"NC","PC","TC","TV","AC","RF","WH","WM"}),{"计算机","计算机","计算机","电视","空调","冰箱","热水器","洗衣机"})

孤云独闲

=LOOKUP(1,0/(LEFT(B4,2)={"NC","PC","TC","TV","AC","RF","WH","WM"}),{"计算机","计算机","计算机","电视","空调","冰箱","热水器","洗衣机"})

缘遇

=VLOOKUP(MID(B4,1,2),$L$5:$M$12,2,)

于雪峰

=VLOOKUP(MID(B4,1,2),$L$5:$M$12,2,)

土炳

lookup升序问题

心隐

lookup升序问题

龙江龙

或者：
=LOOKUP(LEFT(B4,2),{"AC","NC","PC","RF","TC","TV","WH","WM"},{"空调","计算机","计算机","冰箱","计算机","电视","热水器","洗衣机"})
要求第2参数按升序排序。

梦带我旅行

或者：
=LOOKUP(LEFT(B4,2),{"AC","NC","PC","RF","TC","TV","WH","WM"},{"空调","计算机","计算机","冰箱","计算机","电视","热水器","洗衣机"})
要求第2参数按升序排序。

大贲

大佬，果然就是大佬