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
Hello...
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.