EXCEL 在sheet2中输入客户固话或者输入手机号码,如何能自动填充客户名称...答:a2=if(iserror(vlookup(b2,sheet1!b:b,1,)),if(iserror(vlookup(c2,sheet1!c:c,1,)),"未找到",indirect("sheet1!a"&match(c2,sheet1!c:c,0))),indirect("sheet1!a"&match(b2,sheet1!b:b,0)))d2=if(a2<>"未找到",vlookup(a2,sheet1!a:e,4,),"")e2=if(a2<>"未找到"...