# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Question: I want to know how to code this. I want to know how to find out if an item in TABLE 2 exist in TABLE 1, if it exists say "YES" if it doesn't say "NO". Date, Item and Amount has to match.
Solved by C. A. in 34 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 17/10/2017 - 06:49
Question: I want to know how to code this. I want to know how to find out if an item in TABLE 2 exist in TABLE 1, if it exists say "YES" if it doesn't say "NO". Date, Item and Amount has to match.
User 17/10/2017 - 06:49
Hi there! :)
Excelchat Expert 17/10/2017 - 06:49
got it
Excelchat Expert 17/10/2017 - 07:04
Do you see the result?
User 17/10/2017 - 07:04
I can see it.. let me check :)
User 17/10/2017 - 07:06
Does Helper 1 equals to CONCATENATE ?
Excelchat Expert 17/10/2017 - 07:07
yes, we need to concatenate table one data to compare a match
User 17/10/2017 - 07:07
Ok let me test
Excelchat Expert 17/10/2017 - 07:07
sure
User 17/10/2017 - 07:08
Ok so... line 4 now exist but it still says "NO"
User 17/10/2017 - 07:08
I wonder why?
User 17/10/2017 - 07:08
hmm..
Excelchat Expert 17/10/2017 - 07:08
let me check something
User 17/10/2017 - 07:09
Ok thanks!
Excelchat Expert 17/10/2017 - 07:11
Can you check again?
Excelchat Expert 17/10/2017 - 07:12
I don't see any problem
User 17/10/2017 - 07:13
ok
User 17/10/2017 - 07:14
Look at TABLE 2, line 5... it says "NO"
User 17/10/2017 - 07:14
but it does exist int TABLE 1, line 4
Excelchat Expert 17/10/2017 - 07:15
Sorry my mistake.
Excelchat Expert 17/10/2017 - 07:15
It has been corrected.
User 17/10/2017 - 07:16
Ok no worries. :)
User 17/10/2017 - 07:16
No need to apologise. I really appreciate the help. Let me check again.
Excelchat Expert 17/10/2017 - 07:16
Thanks for the patience.
User 17/10/2017 - 07:18
Quick question... under Help 1, is it better to use =B4&C4&D4 instead of =CONCATENATE ?
Excelchat Expert 17/10/2017 - 07:19
yes, functions are sometimes really quick
Excelchat Expert 17/10/2017 - 07:20
anything else?
User 17/10/2017 - 07:20
That's everything. Thank you very much!
User 17/10/2017 - 07:20
You're a GENIUS!!
Excelchat Expert 17/10/2017 - 07:21
Please rate me five star after pressing the end button
User 17/10/2017 - 07:21
If I click END SESSION can I still review the sheet or will it disappear?
Excelchat Expert 17/10/2017 - 07:21
User 17/10/2017 - 07:22
Got it!
User 17/10/2017 - 07:22
Thank you
User 17/10/2017 - 07:22
I'll give you 10/10 STARS
User 17/10/2017 - 07:22
Have a wonderful day

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.