IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A:C,2,0)) 求赐教,此公式的应用IF(COUNTIF(表名!C:C,A4),VLOOKUP(A4,表名!C:F,4,),"")=vlookup(a1,B表!a:b,2,0)

IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A:C,2,0)) 求赐教,此公式的应用IF(COUNTIF(表名!C:C,A4),VLOOKUP(A4,表名!C:F,4,),"")=vlookup(a1,B表!a:b,2,0)
IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A:C,2,0)) 求赐教,此公式的应用
IF(COUNTIF(表名!C:C,A4),VLOOKUP(A4,表名!C:F,4,),"")
=vlookup(a1,B表!a:b,2,0)

IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A:C,2,0)) 求赐教,此公式的应用IF(COUNTIF(表名!C:C,A4),VLOOKUP(A4,表名!C:F,4,),"")=vlookup(a1,B表!a:b,2,0)
IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A:C,2,0))
等于 =VLOOKUP(A:A,sheet1!A:C,2,0))
第1个目的是为了没有查找到数据,不显示#N/A,而显示空白.