Previous Topic Next Topic

Excel function to Check neighbour cells match for all

[Solved/Closed]
Report
Posts
2
Registration date
Thursday June 4, 2015
Status
Member
Last seen
June 7, 2015
 -
 Dan slow -
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.

1 reply

Answer 1 / 1
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
 145
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.
Report
Posts
2
Registration date
Thursday June 4, 2015
Status
Member
Last seen
June 7, 2015
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.
Report

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.
Ask a question