Returning Multiple Data in One Cell

[adamski911]

Hi,

I am looking to return multiple text/numbers from different cells based on one or more criteria but to return these all in one cell.

Example

A B
PO Inv No Inv No PO
7654 121 121 7654 7458 7422 7001 6854
7666 122 122 7666 7964
7458 121 123 7934 6984
7934 123 124 7041
7964 122
7422 121
7041 124
7001 121
6984 123
6854 121

Is there a formula I can use to do this?

Thanks

 

[Fluff]

If you are using 365 then have a look at the textjoin function https://exceljet.net/excel-functions/excel-textjoin-function
Otherwise you'll probably need a macro, or UDF

 

[adamski911]

Thanks, So is this possible to use with a MATCH INDEX function to bring it across?

 

[Fluff]

I very much doubt it, unless you want a formula that's half a mile long.

 

[adamski911]

Thanks for the help. Searching the internet I found a solution which brings in what I need.

https://exceljet.net/formula/multiple-matches-in-comma-separated-list