Partial Match Text/Number Strings

[jpicket2]

I have 9 columns of data (columns A-I). Column B has a long string of model numbers clustered together (Cells C-I concatenate). Cells in columns C-I have individual model numbers. I am looking for a macro (or function) which can check for a partial match with column B in each cell of a given row for columns C-I and then return the part name (Column A) if there is a match. For example, model #11316 would return Armature- 120V, Brush Set, and Washer Set since it occurs in cells B5, B6, and B7.

Is this even possible since there is no identifiable pattern to my data? Thank you very much for any advice. Excel spreadsheet is attached.

Part	String Model Numbers	Model #	Model #	Model #	Model #	Model #	Model #	Model #
Chuck A	1122211236	11222	11236
Cord	11240112471138711388540540432507	11240	11247	11387	11388	RH540	RH540	RH432
Brush Set	112411126411265112481131811321	11241	11248	11318	11264	11265		11321
Armature - 120V	112451131611317	11245			11316	11317
Brush Set	1124511223113111131611317	11245	11223	11311	11316	11317
Armature - 120V	11245112231131111316	11245	11223	11311	11316

<colgroup><col><col><col span="7"></colgroup><tbody>
</tbody>

 

[svendiamond]

model #11316 would return Armature- 120V, Brush Set, and Washer Set since it occurs in cells B5, B6, and B7.

Is cell B7 supposed to say "Washer Set" instead of "Armature - 120V"?

 

[jpicket2]

Yes, sorry about that.