Index Match to a string in one cell regardless of where it is located within cell (beginning, middle, or end)

[ripina]

This one is a tough one.

Trying to perform an index match type function where I can match the Supplier Part Number in Column D14, 15, 16 to the Description in Column A2-8 and then fetch the Mfg#, Manufacturer, and Description.

The example included contains the "answers" in gray Cells G2:I8.

Excel 2010
	A	B	C	D	E	F	G	H	I
1	Description	Item #	Order Number	Business Unit	Address Number	Address Number	MFG #	MFG	MFG Description
2	AB103-1224YZ	1	455069	A	45900	NULL	21113	ARC Abrasive	ACR 1/8 X 3/4 #240 (100)
3	BB103-1232-D	1	455069	A	45900	NULL	21114	ARC Abrasive	ACR 1/8 X 3/4 #320 (100)
4	215-1602	1	444016	A	45900	NULL	47.503	Zam	COMP ZAM TUBE 1 LB.
5	AB103-1224	1	455069	A	45900	NULL	21113	ARC Abrasive	ACR 1/8 X 3/4 #240 (100)
6	1_215-1602CA	1	444016	A	45900	NULL	47.503	Zam	COMP ZAM TUBE 1 LB.
7	AAA103-1232	1	455069	A	45900	NULL	21114	ARC Abrasive	ACR 1/8 X 3/4 #320 (100)
8	103-1232AAA	1	455069	A	45900	NULL	21114	ARC Abrasive	ACR 1/8 X 3/4 #320 (100)
9
10
11
12
13	A	B	Client Part Number	Supplier Part Number	Mfg #	Manufacturer	Description	Manufacturer	Mfg #
14	ITEM	CITY		103-1224	21113	ARC Abrasive	ACR 1/8 X 3/4 #240 (100)	ARC Abrasive	21113
15	ITEM	CITY		103-1232	21114	ARC Abrasive	ACR 1/8 X 3/4 #320 (100)	ARC Abrasive	21114
16	ITEM	CITY		215-1602	47.503	Zam	COMP ZAM TUBE 1 LB.	Zam	47.503
Sheet2