Find any match in Column A to Column B

[mbfoster]

I have two columns of invoice numbers (mostly numbers, some start with "E" - E12345 instead of 67890). I want to find any invoice in column A that also appears in column B. They DO NOT have to be in the same row. I need a yes/no or true/false, I do not necessarily have to have it display the value, although this would not hurt.

Please help. I'm at work and need to figure this out. I've been using excel for a few years, personally, and now about 9 months at work. I'm new to the forum, but I'm sure with my job I will be using it frequently. Thanks.

 

[njimack]

The following formula in Column C will display TRUE if the value in A is found anywhere in column B.

=COUNTIF(B:B,A2)>0

 

[DonkeyOte]

removed - solution provided by Neil.

 

[mbfoster]

Thank you both! Neil's solution worked great. I will definitely be frequenting this board!