Fill column with default values

[quemuenchatocha]

Dear best regards

I am trying to get the values that are located in column B, to be reproduced in column C in the same order as they appear. The problem is that I have entered some formulas that do not allow me to obtain the values I require, and instead they always reproduce the same one (Albania).

Exercice_1.xlsx
	A	B	C	D
1		Region/Country/Area	Population and rates of growth in urban areas and capital cities	Year
2	1	Afghanistan	Afghanistan	2005
3	2	Albania		2010
4	3	Algeria		2015
5	4	American Samoa		2018
6	5	Andorra	Albania	2005
7	6	Angola		2010
8	7	Anguilla		2015
9	8	Antigua and Barbuda		2018
10	9	Argentina	Albania	2005
11	10	Armenia		2010
12	11	Aruba		2015
13	12	Australia		2018
14	13	Austria	Albania	2005
15	14	Azerbaijan		2010
16	15	Bahamas		2015
17	16	Bahrain		2018
18	17	Bangladesh		2005
19				2010
20				2015
21				2018
Example

Cell Formulas
Range	Formula
C2:C5	C2	=IF(D2=2005,INDIRECT("B"&ROW()),"")
C6:C14	C6	=IF(D6=2005,INDIRECT("B"&COUNTA(A2:A4)),"")
A2:A18	A2	=ROW()-1

I would like to know if there is an option that allows me to obtain an appropriate result, i.e., that in cell C6 the value of cell B3 appears, in cell C10 the value of cell B4 appears, in cell C14 the value of cell B5 appears.....

I hope to be clear and understand what I am looking for, I appreciate any information.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1		Region/Country/Area	Population and rates of growth in urban areas and capital cities	Year
2	1	Afghanistan	Afghanistan	2005
3	2	Albania		2010
4	3	Algeria		2015
5	4	American Samoa		2018
6	5	Andorra	Albania	2005
7	6	Angola		2010
8	7	Anguilla		2015
9	8	Antigua and Barbuda		2018
10	9	Argentina	Algeria	2005
11	10	Armenia		2010
12	11	Aruba		2015
13	12	Australia		2018
14	13	Austria	American Samoa	2005
15	14	Azerbaijan		2010
16	15	Bahamas		2015
17	16	Bahrain		2018
18	17	Bangladesh	Andorra	2005
19				2010
20				2015
21				2018
Main

Cell Formulas
Range	Formula
A2:A18	A2	=ROW()-1
C2:C21	C2	=IF(D2=2005,INDEX($B$2:$B$18,COUNTIFS(D$2:D2,2005)),"")

 

[quemuenchatocha]

Dear @Fluff as always your valuable help is impeccable, thank you very much for your attention.
It is exactly what I am looking for
A big hug!

 

[Fluff]

You're welcome & thanks for the feedback.