第二题怎么做？

holiday66 · 发表于 2015-12-19 15:22

第二题怎么做？

hhjjpp · 发表于 2015-12-19 15:34

用公式很简单，if就行了，然后把值粘贴回去

holiday66 · 发表于 2015-12-19 15:39

用什么公式呢？原谅我这只笨鸟

hhjjpp · 发表于 2015-12-19 16:27

=if(d2="机械工程","J"&A2,IF(D2="车辆工程","C"&A2,IF(D2="市场营销","S",)&A2))

hhjjpp · 发表于 2015-12-19 16:31

或者：
=lookup(d2,{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"压","Y";"杂","Z"})&a2

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