Microsoft Excel – Checking if value in Column A exists in Column B
=IFERROR(IF(VLOOKUP(A2,$B:$B,1,FALSE)=A2,"EXISTS"),"DOESNT-EXIST")
Microsoft Excel – Checking if value in Column A exists in Column B =IFERROR(IF(VLOOKUP(A2,$B:$B,1,FALSE)=A2,”EXISTS”),”DOESNT-EXIST”)
=IFERROR(IF(VLOOKUP(A2,$B:$B,1,FALSE)=A2,"EXISTS"),"DOESNT-EXIST")