=LOOKUP("々",VLOOKUP(T(IF(1,LEFT(B2,{2,3})))&"*",Sheet1!A:B,2,))
Excel 实现输入城市得出所对应省份
最新推荐文章于 2024-05-01 23:28:54 发布
=LOOKUP("々",VLOOKUP(T(IF(1,LEFT(B2,{2,3})))&"*",Sheet1!A:B,2,))