把这个套进公式就可以了：
“{"","";"吖","A";"八","B";"嚓","C";"咑","D";"鵽","E";"发","F";"猤","G";"铪","H";"夻","J";"咔","K";"垃","L";"嘸","M";"旀","N";"噢","O";"妑","P";"七","Q";"囕","R";"仨","S";"他","T";"屲","W";"夕","X";"丫","Y";"帀","Z"}”
只是提取拼音字母，“=lookup(left(),{})”就可以了。
根据字母显示符合条件的数据，“=index(……(lookup(……”就OK了。
还是帖上附件吧，也供其他朋友参考：
附件：2.xls
答：庄，麻，席，应，庞，庚，庾，唐，庶，庹，康，廉，廖详情>>
