# Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.