• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup result with multiple values

uday

Member
Hi,

I need an Excel lookup function which will return a multiple values like above mentioned result. Right now I am facing lot of problem to evaluate it and get the perfect result. It should have a concatenate function which will segregate each values with ";".

Regards,
Uday
 

Attachments

  • VlookUp.xlsx
    10.2 KB · Views: 7
See cell F2 in the attached file. Is this what you were looking for?
=VLOOKUP(D2,A:B,2,0)&";"&VLOOKUP(D5,A:B,2,0)&";"&VLOOKUP(D4,A:B,2,0)
 

Attachments

  • Copy of VlookUp.xlsx
    10 KB · Views: 6
Thanks for your quick response Eloise.

Now, the data which I have mentioned(Column D) in my attached file is very less. I have to handle more than five different numbers and I think the above formula will be very long if I want to lookup every numbers in specific table array.

Also, I am getting #N/A for cell numbers F4,F5,F6.

upload_2016-2-14_11-12-55.png

Regards
Uday
 
Maybe,

1] Helper Column C, C2 enter formula :

="; "&B2&IFERROR(VLOOKUP(A2,A3:C$24,3,0),"")

and, C2, Custom Cell Formatting >> in Type box , enter : ;;;

Copy down.

2] Result Column F, F2 enter formula :

=MID(VLOOKUP(D2,A$2:C$24,3,0),3,99)

Copy down.

Regards
Bosco
 

Attachments

  • Copy of VlookUp.xlsx
    11.4 KB · Views: 8
Sorry, find mistake in the Helper Column formula of post #4, herein is the revised :

1] Helper Column C, C2 enter formula :

="; "&B2&IFERROR(VLOOKUP(A2,A3:C$25,3,0),"")

and, select C2 >> Custom Cell Formatting >> in the Type box, enter : ;;;

Copy down.

2] Result Column F, F2 enter formula :

=MID(VLOOKUP(D2,A$2:C$24,3,0),3,99)

Copy down.

Regards
Bosco
 

Attachments

  • Copy of VlookUp2.xlsx
    11.3 KB · Views: 3
Back
Top