I need to check each number in a column to see if the number also appears anywhere in another column. I have tried various IF commands, but can only get a TRUE if the number is on the same row.
I need a TRUE value if the number in the first column is found anywhere in the second column.

Any help would be appreciated.