I have two columns of ID's, A and B. I want to know if each value in column A is in column B.

There's got to be an easy formula for this...thoughts?