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

Question

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

Report

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.

Excel function to Check neighbour cells match for all
Excel function for color of cell - How-To - Excel
Excel check if cell is date ✓ - Forum - Office Software
Excel check if cell is percentage ✓ - Forum - Excel
Excel vba copy row if cell value matches ✓ - Forum - Office Software
Perform a Partial Cell Match in Excel - How-To - Excel

1 reply

Ask a question

Mazzaropi · Answer 1 · 2015-06-04T09:24:58-0400

Answer 1 / 1

Mazzaropi

Posts: 1852
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: November 7, 2020

136
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.

Report

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.

Report

Dan slow
Feb 25, 2016 at 08:12 AM

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.

Your reply