Vlook/Index/Match up with three criteria

[mdonovan890]

I am trying to generate a formula that will automatically populate the following data. I have tired various VLOOKUP, INDEX/MATCH Formula with no luck.

Here's the Data
[TABLE="width: 290"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]FRI NG CHEM RACK 06 C:13 2300120694
FRI NG CHEM RACK 08 D:10 2300120728
FRI NG CHEM RACK 08 A:5 2300120737
FRI NG CHEM RACK 08 B:15 2300120747
FRI NG CHEM RACK 08 H:16 2300120749
FRI NG CHEM RACK 08 H:14 2300120755
FRI NG CHEM RACK 08 A:14 2300120757
FRI NG CHEM RACK 05 J:19 2300120759
FRI NG CHEM RACK 06 J:12 2300120769
FRI NG CHEM RACK 08 A:23 2300120770


[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

When I input [TABLE="width: 166"]
<tbody>[TR]
[TD="width: 166"]FRI NG CHEM RACK 08[/TD]
[/TR]
</tbody>[/TABLE]

I want this to come up
FRI NG CHEM RACK 08

D:10 2300120728
A:5 2300120737
B:15 2300120747
H:16 2300120749
H:14 2300120755
A:14 2300120757
A:23 2300120770

Please help!!

 

[63falcondude]

How's this?

Excel 2010
	A	B	C	D	E
1	Column A Header	Column B Header		Input	Matches
2	FRI NG CHEM RACK 06	C:13 2300120694		FRI NG CHEM RACK 08	D:10 2300120728
3	FRI NG CHEM RACK 08	D:10 2300120728			A:5 2300120737
4	FRI NG CHEM RACK 08	A:5 2300120737			B:15 2300120747
5	FRI NG CHEM RACK 08	B:15 2300120747			H:16 2300120749
6	FRI NG CHEM RACK 08	H:16 2300120749			H:14 2300120755
7	FRI NG CHEM RACK 08	H:14 2300120755			A:14 2300120757
8	FRI NG CHEM RACK 08	A:14 2300120757			A:23 2300120770
9	FRI NG CHEM RACK 05	J:19 2300120759
10	FRI NG CHEM RACK 06	J:12 2300120769
11	FRI NG CHEM RACK 08	A:23 2300120770
Sheet1

Cell Formulas
Range	Formula
E2	{=IFERROR(INDEX($B$2:$B$11, SMALL(IF($D$2=$A$2:$A$11, ROW($A$2:$A$11)-MIN(ROW($A$2:$A$11))+1, ""), ROW(A1))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[mdonovan890]

How's this?

Thank you!!!!

 

[63falcondude]

Thank you!!!!

Glad to help! Merry Christmas!