- ·上一篇：excel表格表页间距宽一些怎么调
- ·下一篇：excel表格怎么分离月日
excel表格怎么给电话打码
2024-10-16 09:18:10
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))