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.

Excel function to Check neighbour cells match for all
Check soft - Download - Finance
How to check pc power consumption in windows 11 - Guide
Tmobile check balance - Guide
Number to words in excel - Guide
Excel date format dd.mm.yyyy - Guide

1 response

Answer 1 / 1

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.

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.

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.

Excel function to Check neighbour cells match for all

1 response

Similar discussions

Subscribe To Our Newsletter!