Multiple lookup criteria with multiple matches

[PREDJ]

Good day.

What solution can you suggest to have “match” return value at column D if the code in column C matches with one of the codes in column G. The current job title code is referenced with the table of possible jobs for completers of certain skills training.

In short, this is a problem of a multiple lookup criteria with multiple matches.

Please help. Thank you.

					Reference table
Trainee	Skills Training Title	Current Job Title Code	match_result
A	Contact Center Services	match		Skills Training Title	Job Title Code
B	Process Inspection	match		Automotive Servicing
C	Consumer Electronics Servicing	not match		Carpentry
D	Refrigeration and Aircon Servicing	match		Consumer Electronics Servicing
E	Flux Cored Services	not match		Consumer Electronics Servicing
F	Process Inspection	not match		Contact Center Services
G	Consumer Electronics Servicing	match		Flux Cored Arc Welding
H	Refrigeration and Aircon Servicing	match		Refrigeration and Aircon Servicing
I	Contact Center Services	match		Refrigeration and Aircon Servicing
J	Instrumentation and Control Servicing	not match		Refrigeration and Aircon Servicing
K	Automotive Servicing	match		Process Inspection
L	Carpentry	match		Process Inspection

<tbody>
[TD="align: center"] A
[/TD]
[TD="align: center"] B
[/TD]
[TD="align: center"] C
[/TD]
[TD="align: center"] D
[/TD]
[TD="align: center"] E
[/TD]
[TD="align: center"] F
[/TD]
[TD="align: center"] G [/TD]

[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]0410[/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]0711[/TD]

[TD="align: center"]0110[/TD]

[TD="align: center"]5[/TD]

[TD="align: center"]0410[/TD]

[TD="align: center"]0210[/TD]

[TD="align: center"]6[/TD]

[TD="align: center"]0612[/TD]

[TD="align: center"]0310[/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]0510[/TD]

[TD="align: center"]0311[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]0611[/TD]

[TD="align: center"]0410[/TD]

[TD="align: center"]9[/TD]

[TD="align: center"]0311[/TD]

[TD="align: center"]0510[/TD]

[TD="align: center"]10[/TD]

[TD="align: center"]0610[/TD]

[TD="align: center"]0610[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]0410[/TD]

[TD="align: center"]0611[/TD]

[TD="align: center"]12[/TD]

[TD="align: center"]0611[/TD]

[TD="align: center"]0612[/TD]

[TD="align: center"]13[/TD]

[TD="align: center"]0110[/TD]

[TD="align: center"]0710[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]0210[/TD]

[TD="align: center"]0711[/TD]

[TD="align: center"]15[/TD]

</tbody>