IF(ISERROR(VLOOKUP(E7,$C$7:$C$11,1,FALSE)),"불일치",IF(VLOOKUP(E7,$C$7:$C$11,1,FALSE)=E7,"일치"))

 

IF(ISERROR(VLOOKUP(H38,$F$38:$F$46,1,FALSE)),"불일치", IF(VLOOKUP(H38,$F$38:$F$46,1,FALSE)=H38,"일치"))

 

IF(LEN(IFERROR(VLOOKUP(D10, 찾을값, 영역, 1, FALSE), "불일치")) = 9, "일치", "불일치")

+ Recent posts