PDA

View Full Version : [SOLVED] Match two columns



Tenspeed39355
09-24-2004, 05:55 AM
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:hi:

CBrine
09-24-2004, 06:17 AM
=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
09-24-2004, 01:06 PM
CBrine Thank you very much. The formula you gave me works just fine.
Again thanks
Max