通过特定字符判断，然后输出不同类型

hypo236709 · 发表于 2024-3-18 11:34

有一版数据，有4个类型，-H为华硕，-Z为联想，-X为惠普，-J为戴尔，手动更改很慢，而且有新增加的数据每次还要手动添加类型，能用什么公式直接判断生成类型的吗？不用每次都手动更改或新增

4种类型如下图所示

祝洪忠- · 发表于 2024-3-18 11:44

本帖最后由祝洪忠- 于 2024-3-18 11:46 编辑

=LOOKUP(1,-FIND({"H","Z","X","J"},A2),{"华硕","联想","惠普","戴尔"})

海马爸爸 · 发表于 2024-3-18 11:47

=VLOOKUP(MID(A1,FIND("-",A1,1),2),{"-H","华硕";"-Z","联想";"-X","惠普";"-J","戴尔"},2,0)

tmplinshi · 发表于 2024-3-18 11:48

复制代码

boyuanoffice · 发表于 2024-3-18 11:51

本帖最后由 boyuanoffice 于 2024-3-18 11:57 编辑

=CHOOSE(MATCH(TRUE,ISNUMBER(FIND({"-H","-Z","-X","-J"},A2)),0),"华硕","联想","惠普","戴尔")

复制代码

复制代码

quqiyuan · 发表于 2024-3-18 13:06

=VLOOKUP(LEFT(TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",99)),100,99))),{"H","华硕";"Z","联想";"X","惠普";"J","戴尔"},2,)

hxj119 · 发表于 2024-3-18 13:24

=LOOKUP(1,-FIND({"-H","-Z","-X","-J"},A2),{"华硕","联想","惠普","戴尔"})

菜狗一只 · 发表于 2024-3-18 15:06

本帖最后由菜狗一只于 2024-3-18 15:07 编辑

复制代码

hypo236709 · 发表于 2024-3-18 16:35

菜狗一只发表于 2024-3-18 15:06

非常感谢！！！！！！！！！！

		自动登录	找回密码
密码			免费注册

[已解决] 通过特定字符判断，然后输出不同类型