Excel function to Check neighbour cells match for all [Solved/Closed]

Frank211 2 Posts Thursday June 4, 2015Registration date June 7, 2015 Last seen - Jun 4, 2015 at 05:06 AM - Latest reply:  Dan slow
- Feb 25, 2016 at 08:12 AM
Hi,

I need to check if (each) cell in column A is having a match in column B, Example as below:

Column A is phone numbers list, column B is messages list ( which will contain a text and one phone number "it should be the same phone number as the one on column A") Now i need to make sure that phone number on A1 is the same phone number that occure on B1,etc. I dont know how to check if A1 phone number is the same phone number on B1 ? or not, and apply the check for all cells in the column? it should show me only if it is not the same.

Many thanks in advance.
See more 

3 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jun 4, 2015 at 09:24 AM
0
Thank you
Franck211, good morning.

Try to use this:

C1 --> =IF(ISERROR(FIND(A2,B2)),"NOT FOUND","OK")
Copy it down.

Please, tell us if it worked for you.

Is it what you want?
I hope it helps.
Frank211 2 Posts Thursday June 4, 2015Registration date June 7, 2015 Last seen - Jun 7, 2015 at 01:55 AM
Yes, thats helped me. the only difference that i used ISNUMBER instead of using ISERROR and it works, Thank you very much for your help.
Hi, is it possible to find the difference between two cells; e.g where A1 has "success is the key to hard work" and B1 has " success key to hard work"... How can I get "is the" in C1? Thanks.