Question

excel中，如A2是一串20位的数字,当19位是不定数字1~7是,分别代表特定数值

1=快递
2＝空地
3＝科第
4＝看低
5＝溃堤
6＝抗敌
7＝抵达
要在B2中，显示上面的特定数值，怎么设置，求教。

Answer 1

=HLOOKUP(MID(A2,19,1),{"1","2","3","4","5","6","7";"快递","空地","科第","看低","溃堤","抗敌","抵达"},2)

Answer 2

=LOOKUP(--MID(A2,19,1),{0,1,2,3,4,5,6,7,8,9},{"?","快递","空地","科第","看低","溃堤","抗敌","抵达","??","???"})