excel表格怎么给电话打码

1.excel工作表中A1单元格输入包含字符后,在B1单元格可自动输入电

在Sheet1的B2输入公式下拉：

=IF(A2="","",LOOKUP(1,0/(FIND(Sheet2!A$2:A$999,A2)*(Sheet2!A$2:A$999<>"")),Sheet2!B$2:B$999))

或者用这公式也行：

=IF(A2="","",SUMPRODUCT(ISNUMBER(FIND(Sheet2!A$2:A$999,A2))*(Sheet2!A$2:A$999<>"")*Sheet2!B$2:B$999))