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.

Equipment	Unit #		Find	CONV
EVENFLOW FEED 1 BELT	PCB0849
EVENFLOW TILT BELT	PCB0850A		Results	DISCH CONV 1 FROM BARREL WASH	PCB0875
UNDERSIZE LENGTH COLLECT BELT	PCB0856			RAW REC WASTE 2 CONV	PCB0893
BARREL WASHER FD BELT 1	PCB0867			RAW REC WASTE 3 CONV	PCB0894
BARREL WASHER FD BELT 2	PCB0868			RAW REC WASTE 4 CONV	PCB0895
SCRUBBER BY PASS BELT	PCB0869			RAW REC WASTE 5 CONV TO HOPPER	PCB0896
DISCH CONV 1 FROM BARREL WASH	PCB0875			DISCH CONV 2 FROM BARREL WASH	PCB0900
RAW REC WASTE 2 CONV	PCB0893			DISCH CONV 3 FROM BARREL WASH	PCB0901
RAW REC WASTE 3 CONV	PCB0894			STEAM PEEL SURGE BIN 1 CONV	PCB0902
RAW REC WASTE 4 CONV	PCB0895			STEAM PEEL SURGE BIN 2 CONV	PCB0915
RAW REC WASTE 5 CONV TO HOPPER	PCB0896			DESKINNER FEED CONV	PCB0926
DISCH CONV 2 FROM BARREL WASH	PCB0900			FEED CONV 1 TO ROLL SIZER	PCB0929A
DISCH CONV 3 FROM BARREL WASH	PCB0901			DISCH CONV 2 TO TRIM ROOM	PCB0929B
STEAM PEEL SURGE BIN 1 CONV	PCB0902
STEAM PEEL HOPPER 1 BELT	PCB0903
STEAM PEEL SURGE BIN 2 CONV	PCB0915
STEAM PEELER HOPPER 2 BELT	PCB0917
STEAM PEEL BYPASS 1 BELT	PCB0925
DESKINNER FEED CONV	PCB0926
FEED CONV 1 TO ROLL SIZER	PCB0929A
DISCH CONV 2 TO TRIM ROOM	PCB0929B

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

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