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,082,480
Messages
5,365,803
Members
400,854
Latest member
zenith_11

Some videos you may like

This Week's Hot Topics

Top