降临汾 发表于 2021-12-12 06:03:19

谢谢谢谢谢谢谢谢谢谢谢谢

莫言暗香 发表于 2021-12-16 09:33:46

谢谢谢谢谢谢谢谢谢谢谢谢

它說它要重生 发表于 2021-12-20 14:20:47

感谢大佬，明白了！

自古知兵多善战 发表于 2021-12-24 07:17:22

感谢大佬，明白了！

徐东明 发表于 2021-12-28 02:34:53

谢谢！那个区域需要删除
不能用V函数

童曦 发表于 2022-1-2 05:34:02

谢谢！那个区域需要删除
不能用V函数

淡淡灬 发表于 2022-1-4 07:09:51

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

幸福在后边 发表于 2022-1-5 10:26:47

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

七横六竖先生 发表于 2022-1-6 09:17:32

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

翰轩 发表于 2022-1-11 21:54:20

=VLOOKUP(MID(B4,1,2),$L$5:$M$12,2,)
页: 1 [2] 3
查看完整版本: LOOKUP+MID 提取字母其中一组异样