金戈加万点 发表于 2022-1-18 06:01:46

lookup升序问题

小蔡看世界 发表于 2022-1-25 18:00:50

lookup升序问题

日后再说 发表于 2022-1-27 01:27:03

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

各路网友 发表于 2022-2-11 04:02:26

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

退后 发表于 2022-2-16 16:35:07

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