Return Multiple Values From Two Columns In Two Separate Workbooks

[DPXCV]

I have two workbooks that I am trying to match up multiple of the same sales orders numbers to different item numbers that fall under the same sales order number.

Column B in both workbooks contain the SO number, I would like to have a formula in column C of the second workbook that returns all the different item numbers in the first book, which is list under column C (see below).

Workbook 1 Workbook2

 

[DPXCV]

Very nice, thanks Fluff!

Fluff, how do I return a zero value if there is no match from Sheet1!$B$2:$B$100=B2

 

[Fluff]

How about

=CHOOSEROWS(FILTER(Sheet1!$C$2:$D$100,Sheet1!$B$2:$B$100=B2,0),COUNTIFS(B$2:B2,B2))

 

[DPXCV]

How about

=CHOOSEROWS(FILTER(Sheet1!$C$2:$D$100,Sheet1!$B$2:$B$100=B2,0),COUNTIFS(B$2:B2,B2))

Thank you.

 

[Fluff]

You're welcome.