月夜青衫 发表于 2021-11-10 09:01:00

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

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






跟随 发表于 2021-11-20 02:49:38

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

孤云独闲 发表于 2021-11-20 16:56:03

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

缘遇 发表于 2021-11-26 06:46:56

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

于雪峰 发表于 2021-11-26 14:54:04

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

土炳 发表于 2021-11-29 03:03:08

lookup升序问题

心隐 发表于 2021-11-29 12:20:55

lookup升序问题

龙江龙 发表于 2021-12-8 18:19:50

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

梦带我旅行 发表于 2021-12-11 19:34:34

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

大贲 发表于 2021-12-11 23:38:50

大佬，果然就是大佬
页: [1] 2 3
查看完整版本: LOOKUP+MID 提取字母其中一组异样