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
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