Capture data range where criteria is met

[colinheslop1984]

If I have a set of data as below
(ignore the dashes, it's just to separate the info as I can't seem to do a table with my phone)

A--------B--------C--------D
1------1901
1------1902
1------1903
2------1904
2------1905
2------1906
3------1907

(This list goes on all the way to 1952)

If d1 contains either 1, 2 or 3, I want cells d2:d14 to display the range from column B, in ascending order, where column A matches criteria set out in D1

Any suggestions?

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1				1
2	1	1901		1901
3	1	1902		1902
4	1	1903		1903
5	2	1904		1910
6	2	1905		1911
7	2	1906		1912
8	3	1907		1919
9	3	1908		1920
10	3	1909		1921
11	1	1910
12	1	1911
13	1	1912
14	2	1913
15	2	1914
16	2	1915
17	3	1916
18	3	1917
19	3	1918
20	1	1919
21	1	1920
22	1	1921
23	2	1922
24	2	1923
25	2	1924
26	3	1925
27	3	1926
All

Cell Formulas
Range	Formula
D2	=IFERROR(INDEX($B$2:$B$27,AGGREGATE(15,6,ROW($A$2:$A$27)-ROW($A$2)+1/($A$2:$A$27=D$1),ROWS($1:1))),"")