Looking to Display a list of results when a cell contains certain text

[beekeeper37]

I am looking for a formula that will give me a list of results based on a text.

This is what I would like to achieve.

[TABLE="width: 802"]
<colgroup><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Equipment[/TD]
[TD]Unit #[/TD]
[TD][/TD]
[TD]Find[/TD]
[TD]CONV[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]EVENFLOW FEED 1 BELT[/TD]
[TD]PCB0849[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]EVENFLOW TILT BELT[/TD]
[TD]PCB0850A[/TD]
[TD][/TD]
[TD]Results[/TD]
[TD]DISCH CONV 1 FROM BARREL WASH[/TD]
[TD]PCB0875[/TD]
[/TR]
[TR]
[TD]UNDERSIZE LENGTH COLLECT BELT[/TD]
[TD]PCB0856[/TD]
[TD][/TD]
[TD] [/TD]
[TD]RAW REC WASTE 2 CONV[/TD]
[TD]PCB0893[/TD]
[/TR]
[TR]
[TD]BARREL WASHER FD BELT 1[/TD]
[TD]PCB0867[/TD]
[TD][/TD]
[TD] [/TD]
[TD]RAW REC WASTE 3 CONV[/TD]
[TD]PCB0894[/TD]
[/TR]
[TR]
[TD]BARREL WASHER FD BELT 2[/TD]
[TD]PCB0868[/TD]
[TD][/TD]
[TD] [/TD]
[TD]RAW REC WASTE 4 CONV[/TD]
[TD]PCB0895[/TD]
[/TR]
[TR]
[TD]SCRUBBER BY PASS BELT[/TD]
[TD]PCB0869[/TD]
[TD][/TD]
[TD] [/TD]
[TD]RAW REC WASTE 5 CONV TO HOPPER[/TD]
[TD]PCB0896[/TD]
[/TR]
[TR]
[TD]DISCH CONV 1 FROM BARREL WASH[/TD]
[TD]PCB0875[/TD]
[TD][/TD]
[TD] [/TD]
[TD]DISCH CONV 2 FROM BARREL WASH[/TD]
[TD]PCB0900[/TD]
[/TR]
[TR]
[TD]RAW REC WASTE 2 CONV[/TD]
[TD]PCB0893[/TD]
[TD][/TD]
[TD] [/TD]
[TD]DISCH CONV 3 FROM BARREL WASH[/TD]
[TD]PCB0901[/TD]
[/TR]
[TR]
[TD]RAW REC WASTE 3 CONV[/TD]
[TD]PCB0894[/TD]
[TD][/TD]
[TD] [/TD]
[TD]STEAM PEEL SURGE BIN 1 CONV[/TD]
[TD]PCB0902[/TD]
[/TR]
[TR]
[TD]RAW REC WASTE 4 CONV[/TD]
[TD]PCB0895[/TD]
[TD][/TD]
[TD] [/TD]
[TD]STEAM PEEL SURGE BIN 2 CONV[/TD]
[TD]PCB0915[/TD]
[/TR]
[TR]
[TD]RAW REC WASTE 5 CONV TO HOPPER[/TD]
[TD]PCB0896[/TD]
[TD][/TD]
[TD] [/TD]
[TD]DESKINNER FEED CONV[/TD]
[TD]PCB0926[/TD]
[/TR]
[TR]
[TD]DISCH CONV 2 FROM BARREL WASH[/TD]
[TD]PCB0900[/TD]
[TD][/TD]
[TD] [/TD]
[TD]FEED CONV 1 TO ROLL SIZER[/TD]
[TD]PCB0929A[/TD]
[/TR]
[TR]
[TD]DISCH CONV 3 FROM BARREL WASH[/TD]
[TD]PCB0901[/TD]
[TD][/TD]
[TD] [/TD]
[TD]DISCH CONV 2 TO TRIM ROOM[/TD]
[TD]PCB0929B[/TD]
[/TR]
[TR]
[TD]STEAM PEEL SURGE BIN 1 CONV[/TD]
[TD]PCB0902[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEAM PEEL HOPPER 1 BELT[/TD]
[TD]PCB0903[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEAM PEEL SURGE BIN 2 CONV[/TD]
[TD]PCB0915[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEAM PEELER HOPPER 2 BELT[/TD]
[TD]PCB0917[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]STEAM PEEL BYPASS 1 BELT[/TD]
[TD]PCB0925
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DESKINNER FEED CONV[/TD]
[TD]PCB0926[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FEED CONV 1 TO ROLL SIZER[/TD]
[TD]PCB0929A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DISCH CONV 2 TO TRIM ROOM[/TD]
[TD]PCB0929B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Is this possible?

Thank you
Wendell

 

[wideboydixon]

Book1
	A	B	C	D	E	F
1	Equipment	Unit #		Find	CONV
2	EVENFLOW FEED 1 BELT	PCB0849
3	EVENFLOW TILT BELT	PCB0850A		Results	DISCH CONV 1 FROM BARREL WASH	PCB0875
4	UNDERSIZE LENGTH COLLECT BELT	PCB0856			RAW REC WASTE 2 CONV	PCB0893
5	BARREL WASHER FD BELT 1	PCB0867			RAW REC WASTE 3 CONV	PCB0894
6	BARREL WASHER FD BELT 2	PCB0868			RAW REC WASTE 4 CONV	PCB0895
7	SCRUBBER BY PASS BELT	PCB0869			RAW REC WASTE 5 CONV TO HOPPER	PCB0896
8	DISCH CONV 1 FROM BARREL WASH	PCB0875			DISCH CONV 2 FROM BARREL WASH	PCB0900
9	RAW REC WASTE 2 CONV	PCB0893			DISCH CONV 3 FROM BARREL WASH	PCB0901
10	RAW REC WASTE 3 CONV	PCB0894			STEAM PEEL SURGE BIN 1 CONV	PCB0902
11	RAW REC WASTE 4 CONV	PCB0895			STEAM PEEL SURGE BIN 2 CONV	PCB0915
12	RAW REC WASTE 5 CONV TO HOPPER	PCB0896			DESKINNER FEED CONV	PCB0926
13	DISCH CONV 2 FROM BARREL WASH	PCB0900			FEED CONV 1 TO ROLL SIZER	PCB0929A
14	DISCH CONV 3 FROM BARREL WASH	PCB0901			DISCH CONV 2 TO TRIM ROOM	PCB0929B
15	STEAM PEEL SURGE BIN 1 CONV	PCB0902
16	STEAM PEEL HOPPER 1 BELT	PCB0903
17	STEAM PEEL SURGE BIN 2 CONV	PCB0915
18	STEAM PEELER HOPPER 2 BELT	PCB0917
19	STEAM PEEL BYPASS 1 BELT	PCB0925
20	DESKINNER FEED CONV	PCB0926
21	FEED CONV 1 TO ROLL SIZER	PCB0929A
22	DISCH CONV 2 TO TRIM ROOM	PCB0929B
Sheet1

Cell Formulas
Range	Formula
F3	=IF($E3="","",VLOOKUP($E3,$A$2:$B$22,2,FALSE))
E3	{=IFERROR(INDEX($A$2:$A$22,SMALL(IF(ISNUMBER(FIND($E$1,$A$2:$A$22)),ROW($A$2:$A$22)-ROW($A$2)+1),ROWS($E$3:$E3))),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD

 

[beekeeper37]

That works perfectly! I just had to remove the curly brackets and then Ctrl+shift+enter the formula.

Thank you so much. That's amazing.

Wendell

 

[wideboydixon]

Yes - note the instructions underneath the formula:

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself

Glad it's working for you.

WBD