VLookup提取首字母之问题

klzldk

请问一下，为什么用VLookup提取首字母之时，为什么有的正确，有的错误。是数组中的界限值出了问题吗？

sry660

给你百度了另一解法，已测试是OK的

1. =LOOKUP(CODE(A2),45217+{0,36,544,1101,1609,1793,2080,2560,2902,3845,4107,4679,5154,5397,5405,5689,6170,6229,7001,7481,7763,8472,9264},{"A","B","C","D","E","F","G","H","J","K","L","M","N","O","P","Q","R","S","T","W","X","Y","Z"})

复制代码

klzldk

sry660 发表于 2016-2-1 13:13
给你百度了另一解法，已测试是OK的

你这个方法，是利用lookup的数组的模糊查找得到的结果？看到Vlookup那个方法确实有缺陷？

9999djx

=VLOOKUP(MID(A2,1,1),{"",0;"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"},2,1)

klzldk

9999djx 发表于 2016-2-1 14:34
=VLOOKUP(MID(A2,1,1),{"",0;"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";" ...

不行呀。

李建军

留个脚印~~

tgydslr

用vlookup并不擅长的模糊查找去做还不如lookUp呢