matching numbers

mypig7

Active Member
Joined
Sep 27, 2004
Messages
285
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
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,118,048
Messages
5,569,879
Members
412,298
Latest member
dietitiann
Top