Match two columns

[Tenspeed39355]

What command do I use to match two columns of letters? If the letters are in both column the result should be "yes" if not then the result should be "no"
Thanks for your help.
Max

[CBrine]

=IF(ISERROR(MATCH(A1,$B$1:$B$7,FALSE)),"No","Yes")

This formula should do what you need.
A1= The value from the first column
$B$1:$B$7 = The entire range of the 2nd column
False=Exact Match

You might need to adjust the ranges.

HTH

Edit: Here's an example

[Tenspeed39355]

CBrine Thank you very much. The formula you gave me works just fine.
Again thanks
Max