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
you can download the file
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.
