• 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

bosco_yip

Excel Ninja
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:
Top