Here is one way: =IF(ISNA(IFERROR(VLOOKUP(A3,Sheet1!A:A,1,FALSE),VLOOKUP(B3,Sheet1!A:A,1,FALSE))),"No","Yes").
確定! 回上一頁