vlookup with multiple source and target columns

Originally Posted by KOKOSEK

If you can create help column G like:

=H3&I3

and put something like (into E3)

Formula:

=IFERROR(INDEX(J:J,MATCH("*"&INDEX(A3:D3,MATCH(1,COUNTIF($G$3:$G$19,"*"&A3:D3&"*"),0))&"*",G:G,0)),"")

accept with CSE and drag it down

Not tested so intensively.

Thanks Kokosek.. but also did not work.. nothing matched.

Capture.JPG