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

降临汾

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

莫言暗香

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

它說它要重生

感谢大佬，明白了！

自古知兵多善战

感谢大佬，明白了！

徐东明

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

童曦

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

淡淡灬

=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,)