Excel - IF Function Problem - Expert Solution

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

How to code this? Eg. Under Table 2 - does D, B, C exist in Table 1? (in that correct order) if so, say YES, if not say NO
Solved by V. U. in 36 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/10/2017 - 03:28
User 17/10/2017 - 03:28
Hi there!
User 17/10/2017 - 03:28
I would really appreciate it if I can get this to work. I've been looking for answer
Excelchat Expert 17/10/2017 - 03:29
Sure... Let me see how to build the solution...
Excelchat Expert 17/10/2017 - 03:30
K L M answer should have been "YES"?
Excelchat Expert 17/10/2017 - 03:30
in table 2?
User 17/10/2017 - 03:30
Yes, you're right!
User 17/10/2017 - 03:30
That's a typo sorry
Excelchat Expert 17/10/2017 - 03:31
no probs.. now i get the question... let me see which solution to build..
User 17/10/2017 - 03:32
Ok thanks!
Excelchat Expert 17/10/2017 - 03:40
Are you able to see the updates on column J...
Excelchat Expert 17/10/2017 - 03:40
thats updated via formula...
Excelchat Expert 17/10/2017 - 03:41
Does this look right?
User 17/10/2017 - 03:41
Ok thanks.. will that work if the value under date is an actual date, and item is just mixed text and number? eg. Apple 10.. and under amount would be $20.16 ?
User 17/10/2017 - 03:44
See, if you look at the code, TABLE 2 line 2, it still says YES even though A,B,C does not exist anymore in TABLE 1
Excelchat Expert 17/10/2017 - 03:45
yes... i'm checking the error with the problem...
User 17/10/2017 - 03:45
Thank you very much. I really appreciate the assistance very much!
Excelchat Expert 17/10/2017 - 03:48
let me take a diff approach for the formula..
User 17/10/2017 - 03:49
Ok :)
Excelchat Expert 17/10/2017 - 03:52
can we add an additional column to table 1?
User 17/10/2017 - 03:53
Is it required for the code to work/
User 17/10/2017 - 03:53
Excelchat Expert 17/10/2017 - 03:54
the solution i'm trying would require an additional dummy column
User 17/10/2017 - 03:54
Ok that's fine
Excelchat Expert 17/10/2017 - 03:55
let me update this.. google sheet.. and we will see if this works..
Excelchat Expert 17/10/2017 - 03:56
I've added a formula driven dummy column E
Excelchat Expert 17/10/2017 - 03:57
and the output is captured on L
Excelchat Expert 17/10/2017 - 03:57
let me know if this solves the problem..
User 17/10/2017 - 03:59
I guess table 1 would look clean if it doesn't have the Dummy column. I'm sure it's possible to move Dummy column to Table 2 but the data is still coming from table 1?
Excelchat Expert 17/10/2017 - 04:00
yes we can move the dummy column to table 2.. and tweak the formula
User 17/10/2017 - 04:00
Also, I'm assuming there's no way for excel code to match three different cells that are in in the same row, but searches under multiple cells?
User 17/10/2017 - 04:01
You can't use CONCENTRATE inside the formula that checks/matches Table 2 with Table 1? It has to be a separate cell in order for the formula to work?
Excelchat Expert 17/10/2017 - 04:01
excel can selectively look for data in multiple cells.. but to have that in the same sequence would not be possible
Excelchat Expert 17/10/2017 - 04:02
when you are checking in table-1.. you cannot use concatenate aganst and array..
User 17/10/2017 - 04:03
Ok gotcha Thank you
Excelchat Expert 17/10/2017 - 04:03
no probs,..
User 17/10/2017 - 04:03
I will review the formula and make it work with my excel sheet
User 17/10/2017 - 04:03
This site is very helpful! :D
User 17/10/2017 - 04:03
I will definitely use it even after the trial/beta version :)
Excelchat Expert 17/10/2017 - 04:03
okies.. have a nice day...
Excelchat Expert 17/10/2017 - 04:04
sure.. please do comeback...
User 17/10/2017 - 04:04
Bye! :)

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc