Compare two columns

[tugal]

Hi

I wanted to compare two columns. If data from column A contains the same data in comlumn B then return A. And if column B contains the same data in column A then return B. In other words both columns should be compared and if there is a match located anywhere in that column then return that value.

Any thoughts?
Thanks

 

[tugal]

Thanks so much. That did the trick - I just wasn't able to figure out how to change it so that it would do what I needed it to do. Thanks again everyone.