matching numbers

mypig7

Active Member
Joined
Sep 27, 2004
Messages
284
I have 2 columns of numbers.

What formula can I use to tell me "yes" if a number that appears in the 1st column (column A) also appears somewhere in the second column (column B).

If it doesn't appear, I want "no" to appear.
The numbers aren't necessarily on the same line if they are in both tables.

Thanks
 

Forum statistics

Threads
1,077,865
Messages
5,336,849
Members
399,106
Latest member
anoufal

Some videos you may like

This Week's Hot Topics

Top