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

Vlookup multiple matches

Ateeb Ali

Member
Dear Sir Need help in formula, vlookup or anything else with multiple matches and compile result in next cell

For example when a number associate with many different matches, it should show all match in one cell with concatenate
File attached with brief detail for easy understanding
 

Attachments

  • CHANDOO.xlsx
    152.9 KB · Views: 4
This formula solution using TEXTJOIN function of which available in Office 365

In G3, array formula (Ctrl+Shift+Enter) copied down :

=TEXTJOIN(", ",1,IF(A$3:A$6804=E3,B$3:B$6804,""))

However, if you don't have Office 365, Vlookup+helper column could also obtain the required result.

66375

Regards
Bosco
 
Last edited:
Try this formula solution with helper column

1] In "Helper column" C3, formula copied down :

=IF(A3=A4,B3&", "&C4,B3)

Remark : To hide "Helper Column" as per your need

2] In "Result column" G3, formula copied down :

=VLOOKUP(E3,A$3:C$6804,3,0)

66380

Regards
Bosco
 

Attachments

  • Textjoin with helper.xlsx
    335.7 KB · Views: 7
Back
Top