求VBA设置,表1有全国省市区县对应的名称,表2A1单元格填带市或带区或带...答:=IFERROR(MID(A2,FIND("市",A2)+1,FIND("县",A2)-FIND("市",A2)),IF(ISERROR(FIND("区",A2)),IF(LEN(A2)-LEN(SUBSTITUTE(A2,"市",""))=1,MID(A2,IFERROR(FIND("省",A2),0)+1,FIND("市",A2)-IFERROR(FIND("省",A2),0)),MID(A2,IFERROR(FIND("市",A2),0)+1,F...
请教excel自动匹配问题:我有全国各级省市区县明细(图1),想让图2中各...答:B二输入 =IF(OR(ISERR(VLOOKUP($A二,Sheeet一!$A:$B,二,)),VLOOKUP($A二,Sheeet一!$A:$B,二,)>B$一),"",B$一) 右拖、拉填充