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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.