Function to conditionally sort data

[stephanie24]

I had a question regarding a fix I am in while trying to analyze a data. Here's what I am lookin for.

A B C D
14 6331
14 8164
14 4731
14 6416
14 8106
15 4764
15 6218
15 6256
15 6372
16 6422
16 4829
16 4941
16 4963
17 6212
17 6371
18 6582
18 6642
18 8143
19 6349
19 6611
19 4710
20 4797
20 4815
20 4831
20 6217
14 6227
14 6364
14 6383

If I put in a value,(say 14) in cell C1, I want all the values in column B corresponding to 14,15,and 16 (in column A) in column D. I think it has something to do with index and match with an if function. It would be really helpful if someone can help me with a function which gives me the desired result. Please find the attached spreadsheet for your reference.
Thank you in advance. <!-- / message --><!-- attachments -->

 

[jbeaucaire]

Not sure how you want to decipher 14, 15 and 16 out of a single entry of 14, but you can tweak the "key" formula to do what you want in that regard.

Excel Workbook
	A	B	C	D	E
1	Code	Value	Key	Search	Values
2	14	6331	1	14	6331
3	14	8164	2		8164
4	14	4731	3		4731
5	14	6416	4		6416
6	14	8106	5		8106
7	15	4764	5		6227
8	15	6218	5		6364
9	15	6256	5		6383
10	15	6372	5
11	16	6422	5
12	16	4829	5
13	16	4941	5
14	16	4963	5
15	17	6212	5
16	17	6371	5
17	18	6582	5
18	18	6642	5
19	18	8143	5
20	19	6349	5
21	19	6611	5
22	19	4710	5
23	20	4797	5
24	20	4815	5
25	20	4831	5
26	20	6217	5
27	14	6227	6
28	14	6364	7
29	14	6383	8
Sheet3