Take next line if condition fulfilled

I have a list of repeating numbers and beside the numbers different types of fruits. so for example

Please Login or Register  to view this content.

Question is how to make a form that when I choose the key 14001 it gives me a list of

Please Login or Register  to view this content.

but when I choose the key 14002 it gives me the list

Please Login or Register  to view this content.

etc.

Here's one way...

Data Range

	A	B	C	D	E
1	Code	Item	------	Code	Item
2	14001	apples		14002	nuts
3	14001	pears			bananas
4	14001	oranges			lemons
5	14001	cherries
6	14002	nuts
7	14002	bananas
8	14002	lemons
9	14003	peaches

This formula entered in E2:

=IFERROR(INDEX(B:B,AGGREGATE(15,6,1/(A$2:A$9=D$2)*ROW(A$2:A$9),ROWS(E$2:E2))),"")

Copy down until you get blanks.

Here's another one that requires the data be sorted or grouped by code (as your sample data).

This formula entered in E2:

=IF(ROWS(E$2:E2)>COUNTIF(A:A,D$2),"",INDEX(B:B,MATCH(D$2,A:A,0)+ROWS(E$2:E2)-1))

Copy down until you get blanks.