Finding Similar Part Numbers between two lists

[Cranman2127]

Hello,
I currently have 2 lists of part numbers
List A contains 80 parts.
List B contains 403 parts.

I'm looking to find a way to return any part number in list B if it has the part number from list A in it.
Example:
List A part TBS-66
List B part numbers i'd want to return: TBS-66, TBS-66-BLK, TBS-66-LP, TBS-66-BLK


Thank you for any help you can provide.

 

[Rick Rothstein]

Hello,
I currently have 2 lists of part numbers
List A contains 80 parts.
List B contains 403 parts.

I'm looking to find a way to return any part number in list B if it has the part number from list A in it.
Example:
List A part TBS-66
List B part numbers i'd want to return: TBS-66, TBS-66-BLK, TBS-66-LP, TBS-66-BLK

Your question is not entirely clear to me. What is in List B... single part numbers per item or comma separated values like you show? Maybe if you show some List A and List B values and then show what you want returned from them, things might be more clear.

Also, what are List A and List B... ranges of cells in Columns A and B, VBA arrays, items in ListBoxes, something else?

 

[Cranman2127]

Your question is not entirely clear to me. What is in List B... single part numbers per item or comma separated values like you show? Maybe if you show some List A and List B values and then show what you want returned from them, things might be more clear.

Also, what are List A and List B... ranges of cells in Columns A and B, VBA arrays, items in ListBoxes, something else?

Hello Rick,
Thanks for replying.
The link below is a link to the file i'm working with.
https://www.dropbox.com/s/i8jt25po8e60j1r/Part Numbers.xlsx?dl=0

I've included the raw data on the first tab, and an example of the results i'm trying to obtain on the second tab.

Thank you for the help!