vlookup with multiple source and target columns

**KOKOSEK** · 03-04-2019, 10:01 AM

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.

**asrivera** · 03-06-2019, 03:37 AM

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

**KOKOSEK** · 03-06-2019, 05:08 AM

Originally Posted by asrivera

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

Attachment 614274

Hmm weird. Check attached file. IMHO works fine.
Did you accept formula with CSE?

**asrivera** · 03-06-2019, 05:19 AM

Originally Posted by KOKOSEK

Hmm weird. Check attached file. IMHO works fine.
Did you accept formula with CSE?

CSE!! i had to google that.. and now it works!! thanks so much! now i will play around with more columns

Re: vlookup with multiple source and target columns