All journal entries
Excel

Excel check if a value in column A exists in column B

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")

Start a build

Tell me where work is getting stuck.

Share the process, bottleneck or idea. I'll reply with a practical first step—not a generic sales pitch.

Sent securely to my inbox. Your details are only used to reply.