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,441
Messages
5,365,539
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top