Excel function to Check neighbour cells match for all

Solved/Closed
Frank211 Posts 2 Registration date Thursday June 4, 2015 Status Member Last seen June 7, 2015 - Jun 4, 2015 at 05:06 AM
 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.
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 4, 2015 at 09:24 AM
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.
0
Frank211 Posts 2 Registration date Thursday June 4, 2015 Status Member Last seen June 7, 2015
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.
0
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.
0