Question description:
This user has given permission to use the problem statement for this
blog.
I have to excel workbooks with customer details. I want to check for common entities to both workbooks. I want to check the phoen numbers (they are listed in 3 columns at each workbook). So, my issue is to make excel check each number from 3 columns in Workbook A, and check them with the numbers in 3 columns in workbook b. If a match is found I want TRUE to be returned. Otherwise FALSE
Solved by G. C. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/07/2018 - 07:26
Greetings!
Excelchat Expert
02/07/2018 - 07:26
Thank you for choosing Got It Pro!
Excelchat Expert
02/07/2018 - 07:26
So you need some help on formulas, right?
User
02/07/2018 - 07:26
right
Excelchat Expert
02/07/2018 - 07:27
Okay, can you put sample data on this workbook we have here?
User
02/07/2018 - 07:27
sure
User
02/07/2018 - 07:27
give me a second
Excelchat Expert
02/07/2018 - 07:27
Sure!
User
02/07/2018 - 07:29
I'm done
Excelchat Expert
02/07/2018 - 07:30
Alright. I will put the validation in Sheet1 - is that what we want?
User
02/07/2018 - 07:30
At Sheet 2, I want to get a YES or NO if one or some or all of the phone numbers of the line exist in Sheet1
Excelchat Expert
02/07/2018 - 07:30
Okay, got it.
Excelchat Expert
02/07/2018 - 07:30
Please give me a few minutes.
User
02/07/2018 - 07:30
ok ty
User
02/07/2018 - 07:33
any news?
Excelchat Expert
02/07/2018 - 07:33
We will get there, hold on.
User
02/07/2018 - 07:33
ok
Excelchat Expert
02/07/2018 - 07:36
There, can you check column E in SHeet2 please?
User
02/07/2018 - 07:38
shouldn't the line 5 return a YES?
Excelchat Expert
02/07/2018 - 07:38
Ah yes, let me just edit the range the formula is looking for.
User
02/07/2018 - 07:39
ok
Excelchat Expert
02/07/2018 - 07:39
There you go.
User
02/07/2018 - 07:40
does this formula check for anything written in columns B C and D, or doe sit check for an exact value?
User
02/07/2018 - 07:41
*exact match
Excelchat Expert
02/07/2018 - 07:41
It checks all values in B C and D if it matches with ANYTHING in Sheet 1 B C and D
User
02/07/2018 - 07:42
yes. ok . i understand how it works.
User
02/07/2018 - 07:42
it seems to be the solution to my problem
Excelchat Expert
02/07/2018 - 07:42
Great, I'm glad to have helped you!
Excelchat Expert
02/07/2018 - 07:42
Please leave a feedback after you end our chat session so we'll know how we did today.
User
02/07/2018 - 07:42
thanks a lot.
User
02/07/2018 - 07:43
Definitely
Excelchat Expert
02/07/2018 - 07:43
Thank you, please come back for any more of your Excel needs!
User
02/07/2018 - 07:43
Have a nice fday
User
02/07/2018 - 07:43
*day
Excelchat Expert
02/07/2018 - 07:43
You too!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.