Return multiple values

[wellsk7]

I have two columns of data. Column A has a category identifier number. Column B has specific item number. Multiple values under column B could fall under 1 value in column A. I need to return all values from column B which fall under a column A category. For example: below you will see in column A that "00132008" shows two column B values associated "3408127 & 4893160". So in my lookup I will need to search off of column A and return all column B values associated with the column A value. I appreciate any guidance someone may provide. Thank you.

[TABLE="width: 197"]
<TBODY>[TR]
[TD]00030000</SPAN>[/TD]
[TD]4581088</SPAN>[/TD]
[/TR]
[TR]
[TD]00030001</SPAN>[/TD]
[TD]4581096</SPAN>[/TD]
[/TR]
[TR]
[TD]00030002</SPAN>[/TD]
[TD]4724001</SPAN>[/TD]
[/TR]
[TR]
[TD]00031000</SPAN>[/TD]
[TD]4581062</SPAN>[/TD]
[/TR]
[TR]
[TD]00031001</SPAN>[/TD]
[TD]4581070</SPAN>[/TD]
[/TR]
[TR]
[TD]00031002</SPAN>[/TD]
[TD]4724035</SPAN>[/TD]
[/TR]
[TR]
[TD]00100001</SPAN>[/TD]
[TD]4868402</SPAN>[/TD]
[/TR]
[TR]
[TD]00101001</SPAN>[/TD]
[TD]1025840</SPAN>[/TD]
[/TR]
[TR]
[TD]00101002</SPAN>[/TD]
[TD]2365369</SPAN>[/TD]
[/TR]
[TR]
[TD]00120004</SPAN>[/TD]
[TD]3634367</SPAN>[/TD]
[/TR]
[TR]
[TD]00132004</SPAN>[/TD]
[TD]3408119</SPAN>[/TD]
[/TR]
[TR]
[TD]00132008</SPAN>[/TD]
[TD]3408127</SPAN>[/TD]
[/TR]
[TR]
[TD]00132008</SPAN>[/TD]
[TD]4893160</SPAN>[/TD]
[/TR]
[TR]
[TD]00133004</SPAN>[/TD]
[TD]3408135</SPAN>[/TD]
[/TR]
[TR]
[TD]00133008</SPAN>[/TD]
[TD]3408143</SPAN>[/TD]
[/TR]
[TR]
[TD]00133008</SPAN>[/TD]
[TD]4893194</SPAN>[/TD]
[/TR]
[TR]
[TD]00161010</SPAN>[/TD]
[TD]1920784</SPAN>[/TD]
[/TR]
[TR]
[TD]00161011</SPAN>[/TD]
[TD]2782225</SPAN>[/TD]
[/TR]
[TR]
[TD]00161011</SPAN>[/TD]
[TD]3998192</SPAN>[/TD]
[/TR]
[TR]
[TD]00161012</SPAN>[/TD]
[TD]2782258</SPAN>[/TD]
[/TR]
[TR]
[TD]00161012</SPAN>[/TD]
[TD]3996949</SPAN>[/TD]
[/TR]
[TR]
[TD]00161014</SPAN>[/TD]
[TD]2782274</SPAN>[/TD]
[/TR]
[TR]
[TD]00161014</SPAN>[/TD]
[TD]3580784</SPAN>[/TD]
[/TR]
[TR]
[TD]00161015</SPAN>[/TD]
[TD]2782241</SPAN>[/TD]
[/TR]
[TR]
[TD]00161017</SPAN>[/TD]
[TD]4779047</SPAN>[/TD]
[/TR]
[TR]
[TD]00161020</SPAN>[/TD]
[TD]4779070</SPAN>[/TD]
[/TR]
[TR]
[TD]00212001</SPAN>[/TD]
[TD]2517183</SPAN>[/TD]
[/TR]
[TR]
[TD]00223003</SPAN>[/TD]
[TD]4367801</SPAN>[/TD]
[/TR]
[TR]
[TD]00223006</SPAN>[/TD]
[TD]4596086</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2></COLGROUP>[/TABLE]

 

[MisterBates]

Take a look at CPearson's StringConcat function.