Spreadsheet: 182752d1348591687-cagr-and-vlookup-example-2
Sheet: Population

Population
Code | Country/Region | Currency | Units | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | Historical CAGR | Forecast CAGR
AU | Australia |  | m | 14.695 | 14.923 | 15.184 | 15.393 | 15.579 | 15.788 | 16.018 | 16.264 | 16.532 | 16.814 | 17.065 | 17.284 | 17.495 | 17.667 | 17.855 | 18.072 | 18.311 | 18.518 | 18.711 | 18.926 | 19.153 | 19.413 | 19.651 | 19.895 | 20.127 | 20.395 | 20.698 | 21.072 | 21.432 | 21.875 | 22.2 | 22.53 | 22.87 | 23.2 | 23.53 | 23.86 | 24.19 | 24.53 | 24.86 | 25.19 | 25.52 | 25.85 | 26.18 | 26.51 | 26.84 | 27.16 | 27.48 | 27.8 | 28.12 | 28.43 | 28.74
BE | Belgium |  | m | 9.8482 | 9.8532 | 9.8563 | 9.8555 | 9.8554 | 9.8583 | 9.8618 | 9.8702 | 9.9017 | 9.9377 | 9.9674 | 10.022 | 10.068 | 10.101 | 10.131 | 10.143 | 10.17 | 10.192 | 10.214 | 10.239 | 10.263 | 10.31 | 10.355 | 10.396 | 10.446 | 10.51 | 10.59 | 10.6 | 10.61 | 10.62 | 10.63 | 10.64 | 10.65 | 10.66 | 10.65 | 10.65 | 10.66 | 10.65 | 10.65 | 10.65 | 10.65 | 10.65 | 10.65 | 10.64 | 10.64 | 10.64 | 10.63 | 10.62 | 10.61 | 10.6 | 10.59
BR | Brazil |  | m | 119 | 121.7 | 124.5 | 127.3 | 130.1 | 132.9 | 135.7 | 138.6 | 141.4 | 144 | 146.8 | 149.394 | 151.9 | 154.3 | 156.7 | 159 | 161.3 | 163.5 | 165.6 | 167.7 | 169.799 | 171.9 | 174 | 176.1 | 178.2 | 180.3 | 182.4 | 184.5 | 186.5 | 188.6 | 190.756 | 192.8 | 194.7 | 196.5 | 198.2 | 199.8 | 201.4 | 202.8 | 204 | 205.2 | 206.3 | 207.5 | 208.5 | 209.6 | 210.5 | 211.5 | 212.4 | 213.3 | 214.2 | 215 | 215.7
CA | Canada |  | m | 24.516 | 24.77 | 25.016 | 25.267 | 25.539 | 25.843 | 26.183 | 26.555 | 26.943 | 27.33 | 27.701 | 28.052 | 28.386 | 28.705 | 29.009 | 29.302 | 29.582 | 29.85 | 30.114 | 30.384 | 30.667 | 30.967 | 31.282 | 31.609 | 31.944 | 32.283 | 32.612 | 32.964 | 33.347 | 33.694 | 34.036 | 34.37 | 34.69 | 35.01 | 35.33 | 35.64 | 35.96 | 36.28 | 36.6 | 36.92 | 37.23 | 37.55 | 37.86 | 38.17 | 38.48 | 38.78 | 39.07 | 39.36 | 39.65 | 39.93 | 40.2
CL | Chile |  | m | – | – | – | – | – | – | – | – | – | – | 13.179 | 13.422 | 13.665 | 13.908 | 14.152 | 14.395 | 14.596 | 14.796 | 14.997 | 15.197 | 15.398 | 15.572 | 15.746 | 15.919 | 16.093 | 16.267 | 16.433 | 16.598 | 16.763 | 16.929 | 17.094 | 17.25 | 17.4 | 17.56 | 17.71 | 17.87 | 17.9 | 18.03 | 18.15 | 18.27 | 18.39 | 18.5 | 18.61 | 18.71 | 18.81 | 18.91 | 18.99 | 19.08 | 19.15 | 19.22 | 19.29
CN | China |  | m | – | 967.279 | 980.946 | 995.288 | 1010.321 | 1026.06 | 1042.522 | 1059.096 | 1076.076 | 1093.473 | 1111.295 | 1129.554 | 1145.046 | 1159.145 | 1172.474 | 1185.625 | 1198.308 | 1210.506 | 1223.313 | 1234.857 | 1245 | 1252 | 1258 | 1263 | 1270 | 1276 | 1283 | 1290 | 1297 | 1305 | 1313 | 1321 | 1329 | 1336 | 1343 | 1350 | 1356 | 1361 | 1366 | 1370 | 1373 | 1376 | 1378 | 1379 | 1379 | 1379 | 1378 | 1377 | 1375 | 1373 | 1370
EA | Euro Area |  | m | 277.9 | 279 | 279.8 | 280.4 | 280.9 | 281.6 | 282.4 | 283.1 | 284.2 | 285.8 | 303.5 | 304.6 | 306.1 | 307.2 | 308 | 308.9 | 309.6 | 310.2 | 310.7 | 311.6 | 312.8 | 315.1 | 317 | 319 | 320.8 | 322.9 | 324.5 | 326 | 327 | 327.9 | 328.7 | 329.6 | 330.5 | 331.5 | 332.5 | 333.5 | 334.3 | – | – | – | – | – | – | – | – | – | – | – | – | – | –
FR | France |  | m | 53.88 | 54.182 | 54.493 | 54.772 | 55.026 | 55.284 | 55.547 | 55.824 | 56.118 | 56.423 | 56.691 | 56.961 | 57.224 | 57.457 | 57.644 | 57.83 | 58.012 | 58.19 | 58.381 | 58.653 | 59.034 | 59.456 | 59.866 | 60.284 | 60.705 | 61.15 | 61.57 | 61.95 | 62.28 | 62.61 | 62.95 | 63.29 | 63.63 | 63.98 | 64.35 | 64.74 | 65.12 | 65.32 | 65.51 | 65.69 | 65.87 | 66.04 | 66.2 | 66.35 | 66.5 | 66.63 | 66.77 | 66.89 | 67.01 | 67.12 | 67.22
DE | Germany |  | m | 61.658 | 61.713 | 61.546 | 61.307 | 61.049 | 61.02 | 61.14 | 61.238 | 61.715 | 62.679 | 79.753 | 80.275 | 80.975 | 81.338 | 81.539 | 81.817 | 82.012 | 82.057 | 82.037 | 82.163 | 82.26 | 82.44 | 82.537 | 82.532 | 82.501 | 82.438 | 82.315 | 82.218 | 82.002 | 81.802 | 81.709 | 81.67 | 81.67 | 81.76 | 81.89 | 82.09 | 82.23 | 82.15 | 82.08 | 81.99 | 81.91 | 81.82 | 81.72 | 81.61 | 81.5 | 81.37 | 81.24 | 81.1 | 80.94 | 80.78 | 80.61
HK | Hong Kong |  | m | 5.0631 | 5.1834 | 5.2645 | 5.3451 | 5.3979 | 5.4562 | 5.5246 | 5.5845 | 5.6284 | 5.6607 | 5.688 | 5.752 | 5.8297 | 5.9345 | 6.0673 | 6.2253 | 6.3916 | 6.4959 | 6.5446 | 6.5993 | 6.6587 | 6.7134 | 6.7625 | 6.8097 | 6.8551 | 6.8987 | 6.9404 | 6.9804 | 7.0186 | 7.0551 | 7.0897 | 7.1225 | 7.154 | 7.183 | 7.21 | 7.235 | 7.259 | 7.28 | 7.298 | 7.315 | 7.328 | 7.34 | 7.348 | 7.353 | 7.355 | 7.355 | 7.35 | 7.343 | 7.331 | 7.315 | 7.294
IN | India |  | m | 678.326 | 692.987 | 707.977 | 723.306 | 738.98 | 755.008 | 770.903 | 787.151 | 803.761 | 820.741 | 838.099 | 853.724 | 869.09 | 884.943 | 901.176 | 917.772 | 934.692 | 951.861 | 969.153 | 986.477 | 1004.124 | 1021.967 | 1039.691 | 1057.504 | 1075.473 | 1093.563 | 1111.714 | 1129.866 | 1148 | 1166 | 1184 | 1202 | 1220 | 1238 | 1256 | 1274 | 1292 | 1309 | 1327 | 1345 | 1362 | 1380 | 1397 | 1415 | 1432 | 1449 | 1466 | 1483 | 1500 | 1516 | 1533
ID | Indonesia |  | m | 151.21 | 154.084 | 157.023 | 160.031 | 163.108 | 166.256 | 169.217 | 172.247 | 175.348 | 178.522 | 181.77 | 184.937 | 188.108 | 191.272 | 194.482 | 197.764 | 201.118 | 204.358 | 207.534 | 210.72 | 213.829 | 216.937 | 220.019 | 223.07 | 226.004 | 228.896 | 231.82 | 234.694 | 237.512 | 240.272 | 242.968 | 245.6 | 248.2 | 250.8 | 253.3 | 255.8 | 258.2 | 260.6 | 262.9 | 265.3 | 267.5 | 269.8 | 272 | 274.2 | 276.4 | 278.5 | 280.6 | 282.7 | 284.7 | 286.7 | 288.7
IT | Italy |  | m | 56.22 | 56.384 | 56.519 | 56.634 | 56.72 | 56.774 | 56.815 | 56.834 | 56.835 | 56.834 | 56.833 | 56.854 | 56.895 | 56.936 | 56.965 | 56.97 | 56.942 | 56.887 | 56.853 | 56.87 | 56.985 | 57.201 | 57.499 | 57.866 | 58.263 | 58.672 | 59.082 | 59.495 | 59.893 | 60.252 | 60.55 | 60.79 | 60.96 | 61.09 | 61.18 | 61.24 | 61.29 | 61.31 | 61.32 | 61.31 | 61.29 | 61.27 | 61.24 | 61.2 | 61.16 | 61.12 | 61.06 | 61.02 | 60.96 | 60.91 | 60.85
JP | Japan |  | m | 116.783 | 117.532 | 118.303 | 119.097 | 119.914 | 120.754 | 121.23 | 121.747 | 122.303 | 122.9 | 123.537 | 123.946 | 124.329 | 124.668 | 125.014 | 125.341 | 125.645 | 125.956 | 126.246 | 126.494 | 126.729 | 126.972 | 127.187 | 127.358 | 127.48 | 127.537 | 127.515 | 127.433 | 127.288 | 127.1 | 126.8 | 126.5 | 126.1 | 125.7 | 125.2 | 124.7 | 124.2 | 123.6 | 123 | 122.3 | 121.6 | 120.9 | 120.2 | 119.4 | 118.6 | 117.8 | 117 | 116.1 | 115.3 | 114.4 | 113.5
MX | Mexico |  | m | 68.347 | 69.969 | 71.641 | 73.363 | 75.08 | 76.767 | 78.442 | 80.122 | 81.782 | 83.367 | 84.914 | 86.488 | 88.111 | 89.749 | 91.338 | 92.88 | 94.399 | 95.895 | 97.325 | 98.617 | 99.927 | 101.247 | 102.48 | 103.718 | 104.96 | 106.203 | 107.45 | 108.701 | 109.955 | 111.212 | 112.469 | 113.824 | 115 | 116.2 | 117.5 | 118.8 | 120.1 | 121.4 | 122.6 | 123.8 | 125 | 126.2 | 127.3 | 128.5 | 129.6 | 130.7 | 131.8 | 132.8 | 133.9 | 134.9 | 135.9
NL | Netherlands |  | m | 14.091 | 14.209 | 14.286 | 14.34 | 14.395 | 14.454 | 14.529 | 14.615 | 14.715 | 14.805 | 14.893 | 15.01 | 15.129 | 15.239 | 15.342 | 15.424 | 15.494 | 15.567 | 15.654 | 15.76 | 15.864 | 15.987 | 16.105 | 16.193 | 16.258 | 16.306 | 16.334 | 16.358 | 16.405 | 16.486 | 16.575 | 16.66 | 16.74 | 16.81 | 16.88 | 16.96 | 17.04 | 17.07 | 17.11 | 17.16 | 17.2 | 17.24 | 17.28 | 17.33 | 17.37 | 17.41 | 17.44 | 17.48 | 17.51 | 17.54 | 17.56
NZ | New Zealand |  | m | 3.2063 | 3.2327 | 3.2764 | 3.3089 | 3.3231 | 3.3282 | 3.3556 | 3.3688 | 3.382 | 3.4155 | 3.4592 | 3.4951 | 3.5317 | 3.5722 | 3.62 | 3.6734 | 3.732 | 3.8058 | 3.8312 | 3.8509 | 3.873 | 3.9162 | 3.9895 | 4.0616 | 4.1142 | 4.1607 | 4.211 | 4.2559 | 4.301 | 4.344 | 4.388 | 4.434 | 4.48 | 4.527 | 4.575 | 4.623 | 4.672 | 4.708 | 4.743 | 4.778 | 4.812 | 4.846 | 4.879 | 4.911 | 4.942 | 4.972 | 5.001 | 5.028 | 5.055 | 5.081 | 5.105
PL | Poland |  | m | – | – | – | – | – | – | – | – | – | 38.009 | 38.124 | 38.221 | 38.301 | 38.358 | 38.405 | 38.404 | 38.405 | 38.396 | 38.374 | 38.331 | 38.293 | 38.251 | 38.23 | 38.205 | 38.183 | 38.166 | 38.141 | 38.121 | 38.112 | 38.164 | 38.206 | 38.18 | 38.08 | 38.06 | 38 | 37.96 | 37.96 | 37.87 | 37.78 | 37.68 | 37.56 | 37.44 | 37.31 | 37.16 | 37.02 | 36.86 | 36.7 | 36.54 | 36.36 | 36.19 | 36
SG | Singapore |  | m | 2.4139 | 2.5328 | 2.6465 | 2.6811 | 2.7322 | 2.736 | 2.7334 | 2.7748 | 2.8461 | 2.9309 | 3.0471 | 3.1351 | 3.2307 | 3.3135 | 3.419 | 3.5245 | 3.6707 | 3.796 | 3.9272 | 3.9587 | 4.0279 | 4.138 | 4.176 | 4.1148 | 4.1667 | 4.2658 | 4.4014 | 4.5886 | 4.8394 | 4.985 | 5.077 | 5.2017 | 5.38 | 5.524 | 5.667 | 5.797 | 5.926 | 5.941 | 5.953 | 5.961 | 5.966 | 5.967 | 5.964 | 5.958 | 5.949 | 5.937 | 5.921 | 5.903 | 5.882 | 5.858 | 5.833
KR | South Korea |  | m | 38.12 | 38.72 | 39.33 | 39.91 | 40.41 | 40.81 | 41.21 | 41.62 | 42.03 | 42.45 | 42.87 | 43.295 | 43.745 | 44.195 | 44.641 | 45.094 | 45.525 | 45.954 | 46.287 | 46.617 | 47.008 | 47.389 | 47.64 | 47.874 | 48.03 | 48.14 | 48.439 | 48.643 | 49.006 | 49.195 | 49.424 | 49.757 | 50 | 49.91 | 50 | 50 | 50 | 50.04 | 50.08 | 50.12 | 50.16 | 50.19 | 50.2 | 50.21 | 50.21 | 50.2 | 50.17 | 50.13 | 50.07 | 49.98 | 49.87
ES | Spain |  | m | 37.418 | 37.636 | 37.845 | 38.041 | 38.204 | 38.353 | 38.485 | 38.587 | 38.675 | 38.757 | 38.826 | 38.875 | 39.004 | 39.132 | 39.247 | 39.343 | 39.431 | 39.525 | 39.639 | 39.803 | 40.05 | 41.117 | 41.838 | 42.717 | 43.198 | 44.109 | 44.709 | 45.2 | 45.53 | 45.76 | 45.92 | 46.13 | 46.32 | 46.5 | 46.73 | 46.83 | 46.92 | 47.24 | 47.55 | 47.84 | 48.11 | 48.37 | 48.62 | 48.85 | 49.08 | 49.29 | 49.5 | 49.7 | 49.9 | 50.09 | 50.28
TW | Taiwan |  | m | – | – | – | – | – | – | – | – | – | – | 20.278 | 20.493 | 20.687 | 20.886 | 21.093 | 21.29 | 21.458 | 21.638 | 21.834 | 22.008 | 22.183 | 22.336 | 22.451 | 22.543 | 22.622 | 22.701 | 22.782 | 22.859 | 22.921 | 22.974 | 23.025 | 23.07 | 23.11 | 23.15 | 23.18 | 23.21 | 23.24 | 23.29 | 23.35 | 23.41 | 23.47 | 23.53 | 23.59 | 23.64 | 23.69 | 23.73 | 23.77 | 23.79 | 23.81 | 23.82 | 23.81
GB | United Kingdom |  | m | 56.424 | 56.357 | 56.291 | 56.316 | 56.409 | 56.554 | 56.684 | 56.804 | 56.917 | 57.077 | 57.238 | 57.439 | 57.584 | 57.714 | 57.862 | 58.025 | 58.164 | 58.315 | 58.475 | 58.684 | 58.886 | 59.113 | 59.319 | 59.552 | 59.842 | 60.235 | 60.584 | 60.986 | 61.398 | 61.792 | 62.262 | 62.72 | 63.14 | 63.56 | 64 | 64.44 | 64.86 | 65.3 | 65.73 | 66.17 | 66.61 | 67.05 | 67.48 | 67.91 | 68.33 | 68.74 | 69.15 | 69.54 | 69.93 | 70.3 | 70.67
US | United States of America |  | m | 227.726 | 229.966 | 232.188 | 234.307 | 236.348 | 238.466 | 240.651 | 242.804 | 245.021 | 247.342 | 249.623 | 252.981 | 256.514 | 259.919 | 263.126 | 266.278 | 269.394 | 272.647 | 275.854 | 279.04 | 282.172 | 285.082 | 287.804 | 290.326 | 293.046 | 295.753 | 298.593 | 301.58 | 304.375 | 307.007 | 309.4 | 311.8 | 314.3 | 317 | 319.5 | 322.1 | 325 | 327.6 | 330.2 | 332.8 | 335.4 | 338 | 340.6 | 343.2 | 345.9 | 348.6 | 351.2 | 354 | 356.7 | 359.5 | 362.3
VN | Vietnam |  | m | 53.697 | 54.721 | 55.686 | 56.655 | 57.693 | 58.871 | 60.252 | 61.753 | 63.266 | 64.906 | 67.283 | 68.64 | 69.941 | 71.244 | 72.539 | 73.772 | 74.941 | 76.049 | 77.092 | 78.09 | 79.06 | 79.999 | 80.908 | 81.791 | 82.663 | 83.536 | 84.4 | 85.26 | 86.12 | 86.97 | 87.81 | 88.66 | 89.52 | 90.38 | 91.25 | 92.12 | 92.99 | 93.85 | 94.7 | 95.53 | 96.34 | 97.12 | 97.88 | 98.62 | 99.31 | 99.98 | 100.6 | 101.2 | 101.8 | 102.3 | 102.8
Copyright © 2012 The Economist Intelligence Unit.