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

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

<colgroup><col><col></colgroup><tbody>
</tbody>

When I input

FRI NG CHEM RACK 08

<tbody>
</tbody>

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!