Spreadsheet: 790915d1660059792-inferring-data-in-a-cell-from-data-in-another-column-xlookup-does-not-work-in-this-case-samplefr
Sheet: Sheet1

Name | Status | Population Census 1975-02-20 | Population Census 1982-03-04 | Population Census 1990-03-05 | Population Census 1999-03-08 | Population Estimate 2007-01-01 | Population Estimate 2015-01-01 | Population Estimate 2019-01-01 | Population Estimate 2022-01-01 | Region Name
Auvergne - Rhône - Alpes | Region | 6111163 | 6348625 | 6671915 | 6954285 | 7405206 | 7877698 | 8042936 | 8153233
Ain | Department | 376477 | 418516 | 471019 | 515270 | 574377 | 631877 | 652432 | 665391
Allier | Department | 378406 | 369580 | 357710 | 344721 | 343114 | 341613 | 335975 | 331757
Ardèche | Department | 257065 | 267970 | 277581 | 286023 | 309456 | 324209 | 328278 | 330865
Cantal | Department | 166549 | 162838 | 158723 | 150778 | 149057 | 146219 | 144692 | 143280
Drôme | Department | 361847 | 389781 | 414072 | 437778 | 473428 | 504637 | 516762 | 524506
Haute-Loire | Department | 205491 | 205895 | 206568 | 209113 | 220437 | 227034 | 227570 | 227224
Haute-Savoie | Department | 447795 | 494505 | 568286 | 631679 | 706708 | 793938 | 826094 | 850125
Isère | Department | 860339 | 936771 | 1016228 | 1094006 | 1178714 | 1251060 | 1271166 | 1285915
Loire | Department | 742396 | 739521 | 746288 | 728524 | 740668 | 759411 | 765634 | 767549
[NAME] | Department | 580033 | 594365 | 598213 | 604266 | 626639 | 647501 | 662152 | 672494
[NAME] | Department | 1429647 | 1445208 | 1508966 | 1578869 | 1677073 | 1821995 | 1875747 | 1912073
Savoie | Department | 305118 | 323675 | 348261 | 373258 | 405535 | 428204 | 436434 | 442054
Bourgogne - Franche-Comté | Region | 2631260 | 2680103 | 2706929 | 2727126 | 2792562 | 2820940 | 2805580 | 2785393
Côte-d'Or | Department | 456070 | 473548 | 493866 | 506755 | 519143 | 533147 | 534124 | 534424
Doubs | Department | 471082 | 477163 | 484770 | 499062 | 520133 | 536959 | 543974 | 547572
Haute-Saône | Department | 222254 | 231962 | 229650 | 229732 | 237197 | 237706 | 235313 | 232531
[NAME] | Department | 238856 | 242925 | 248759 | 250857 | 258897 | 260587 | 259199 | 257128
Nièvre | Department | 245212 | 239635 | 233278 | 225198 | 221488 | 211747 | 204452 | 199373
Saône-et-Loire | Department | 569810 | 571852 | 559413 | 544893 | 551842 | 555408 | 551493 | 546577
Territoire de Belfort | Department | 128125 | 131999 | 134097 | 137408 | 142444 | 144483 | 141318 | 137714
[NAME] | Department | 299851 | 311019 | 323096 | 333221 | 341418 | 340903 | 335707 | 330074
Bretagne | Region | 2595431 | 2707886 | 2795638 | 2906197 | 3120288 | 3293850 | 3354854 | 3402932
Côtes-d'Armor | Department | 525556 | 538869 | 538395 | 542373 | 576049 | 598357 | 600582 | 601354
Finistère | Department | 804088 | 828364 | 838687 | 852418 | 885906 | 907796 | 915090 | 922797
Ille-et-Vilaine | Department | 702199 | 749764 | 798718 | 867533 | 955846 | 1042884 | 1079498 | 1107860
Morbihan | Department | 563588 | 590889 | 619838 | 643873 | 702487 | 744813 | 759684 | 770921
Centre - Val de Loire | Region | 2152500 | 2264164 | 2371036 | 2440329 | 2526919 | 2578592 | 2573180 | 2564915
[NAME] | Department | 316350 | 320174 | 321559 | 314428 | 314599 | 308992 | 302306 | 296904
Eure-et-Loir | Department | 335151 | 362813 | 396073 | 407665 | 422411 | 434035 | 431575 | 427776
[NAME] | Department | 248523 | 243191 | 237510 | 231139 | 232799 | 224200 | 219316 | 215031
[NAME]-et-Loire | Department | 478597 | 506093 | 529345 | 554003 | 583086 | 604966 | 610079 | 613406
[NAME] | Department | 490189 | 535669 | 580612 | 618126 | 647733 | 673349 | 680434 | 686200
Loir-et-Cher | Department | 283690 | 296224 | 305937 | 314968 | 326291 | 333050 | 329470 | 325598
Corse | Region | 225562 | 240178 | 250371 | 260196 | 299209 | 327283 | 340440 | 349465
Corse-du-Sud | Department | 100278 | 108604 | 118808 | 118593 | 139362 | 152730 | 158507 | 162314
Haute-Corse | Department | 125284 | 131574 | 131563 | 141603 | 159847 | 174553 | 181933 | 187151
Grand Est | Region | 5185039 | 5231931 | 5278005 | 5386939 | 5506686 | 5559051 | 5556219 | 5542094
Ardennes | Department | 309306 | 302338 | 296357 | 290130 | 284749 | 277752 | 270582 | 265285
Aube | Department | 284823 | 289300 | 289207 | 292131 | 300840 | 309056 | 310242 | 311083
Bas-Rhin | Department | 882121 | 915676 | 953053 | 1026120 | 1084840 | 1116658 | 1140057 | 1156546
Haute-Marne | Department | 212304 | 210670 | 204067 | 194873 | 187407 | 179154 | 172512 | 166343
Haut-Rhin | Department | 635209 | 650372 | 671319 | 708025 | 742408 | 762607 | 767086 | 768557
Marne | Department | 530454 | 543670 | 558276 | 565284 | 566561 | 572293 | 566855 | 562545
Meurthe-et-Moselle | Department | 722693 | 716964 | 711943 | 713779 | 726592 | 734403 | 733760 | 731006
Meuse | Department | 203799 | 199983 | 196223 | 192198 | 193962 | 190626 | 184083 | 178156
Moselle | Department | 1006373 | 1007189 | 1011302 | 1023447 | 1039023 | 1044486 | 1046543 | 1044398
Vosges | Department | 397957 | 395769 | 386258 | 380952 | 380304 | 372016 | 364499 | 358175
Hauts-de-France | Region | 5592362 | 5673217 | 5775686 | 5854014 | 5921960 | 6009976 | 6004947 | 5987172
Aisne | Department | 533807 | 533927 | 537200 | 535434 | 537750 | 538659 | 531345 | 524403
Nord | Department | 2511478 | 2520526 | 2531855 | 2555020 | 2564950 | 2605238 | 2608346 | 2606873
Oise | Department | 606320 | 661781 | 725603 | 766441 | 796624 | 821552 | 829419 | 833013
Pas-de-Calais | Department | 1402295 | 1412413 | 1433203 | 1441568 | 1456726 | 1472648 | 1465278 | 1456555
Somme | Department | 538462 | 544570 | 547825 | 555551 | 565910 | 571879 | 570559 | 566328
Île-de-France | Region | 9878565 | 10073059 | 10660554 | 10952011 | 11598866 | 12082144 | 12262544 | 12395148
Essonne | Department | 923063 | 988000 | 1084824 | 1134238 | 1201994 | 1276233 | 1301659 | 1315404
Hauts-de-Seine | Department | 1438930 | 1387039 | 1391658 | 1428881 | 1544411 | 1601569 | 1624357 | 1643080
Paris | Department | 2299830 | 2176243 | 2152423 | 2125246 | 2193030 | 2206488 | 2165423 | 2139907
Seine-et-Marne | Department | 755762 | 887112 | 1078166 | 1193767 | 1289524 | 1390121 | 1421197 | 1443796
Seine-Saint-Denis | Department | 1322127 | 1324301 | 1381197 | 1382861 | 1502340 | 1592663 | 1644903 | 1678367
Val-de-Marne | Department | 1215713 | 1193655 | 1215538 | 1227250 | 1302889 | 1372389 | 1407124 | 1434351
Val-d'Oise | Department | 840885 | 920598 | 1049598 | 1105464 | 1160721 | 1215390 | 1249674 | 1276534
Yvelines | Department | 1082255 | 1196111 | 1307150 | 1354304 | 1403957 | 1427291 | 1448207 | 1463709
Normandie | Region | 2901847 | 3006341 | 3128565 | 3202385 | 3278145 | 3339131 | 3325032 | 3307286
Calvados | Department | 560354 | 589025 | 617991 | 647873 | 673144 | 693042 | 694905 | 695310
Eure | Department | 422952 | 462254 | 513818 | 541054 | 572105 | 601948 | 599507 | 593885
Manche | Department | 452275 | 466482 | 480123 | 481983 | 495676 | 499824 | 495045 | 491281
Orne | Department | 293523 | 295472 | 293204 | 292337 | 292609 | 286618 | 279942 | 273214
Seine-Maritime | Department | 1172743 | 1193108 | 1223429 | 1239138 | 1244611 | 1257699 | 1255633 | 1253596
Nouvelle-Aquitaine | Region | 4817190 | 4961927 | 5113789 | 5259366 | 5627671 | 5911482 | 6010289 | 6081985
Charente | Department | 337064 | 340770 | 341993 | 339628 | 349535 | 353613 | 352015 | 350298
Charente-Maritime | Department | 497859 | 513220 | 527146 | 557024 | 605410 | 639938 | 651358 | 659482
Corrèze | Department | 240363 | 241448 | 237908 | 232576 | 242038 | 241871 | 240073 | 238445
Creuse | Department | 146214 | 139968 | 131349 | 124470 | 123861 | 120365 | 116617 | 113711
[NAME] | Department | 335829 | 342812 | 345965 | 344392 | 362944 | 374435 | 374878 | 374426
Dordogne | Department | 373179 | 377356 | 386365 | 388293 | 406793 | 415417 | 413223 | 411087
Gironde | Department | 1061480 | 1127546 | 1213499 | 1287334 | 1409345 | 1548478 | 1623749 | 1681330
Haute-Vienne | Department | 352149 | 355737 | 353593 | 353893 | 371102 | 375795 | 372359 | 369805
Landes | Department | 288323 | 297424 | 311461 | 327334 | 367492 | 403234 | 413690 | 422332
Lot-et-Garonne | Department | 292616 | 298522 | 305989 | 305380 | 324170 | 333417 | 331271 | 329135
[NAME] | Department | 534748 | 555696 | 578516 | 600018 | 643090 | 670032 | 682621 | 691770
[NAME] | Department | 357366 | 371428 | 380005 | 399024 | 421891 | 434887 | 438435 | 440164
[NAME] | Region | 4057772 | 4251833 | 4545648 | 4847335 | 5371117 | 5774185 | 5933185 | 6053548
Ariège | Department | 137857 | 135725 | 136455 | 137205 | 148568 | 152499 | 153287 | 153126
Aude | Department | 272366 | 280686 | 298712 | 309770 | 345779 | 366957 | 374070 | 379844
Aveyron | Department | 278306 | 278654 | 270141 | 263808 | 274425 | 279169 | 279595 | 280254
Gard | Department | 494575 | 530478 | 585049 | 623125 | 689847 | 738189 | 748437 | 753436
Gers | Department | 175366 | 174154 | 174587 | 172335 | 183615 | 190932 | 191377 | 192279
Haute-Garonne | Department | 777431 | 824501 | 925962 | 1046338 | 1202920 | 1335103 | 1400039 | 1452055
Hautes-Pyrénées | Department | 227222 | 227922 | 224759 | 222368 | 228594 | 228582 | 229567 | 231014
Hérault | Department | 648202 | 706499 | 794603 | 896441 | 1011207 | 1120190 | 1175623 | 1217787
Lot | Department | 150778 | 154533 | 155816 | 160197 | 171173 | 173400 | 174094 | 174522
Lozère | Department | 74825 | 74294 | 72825 | 73509 | 76880 | 76309 | 76604 | 76573
Pyrénées-Orientales | Department | 299506 | 334557 | 363796 | 392803 | 437157 | 471038 | 479979 | 485396
Tarn | Department | 338024 | 339345 | 342723 | 343402 | 369189 | 386543 | 389844 | 393046
Tarn-et-Garonne | Department | 183314 | 190485 | 200220 | 206034 | 231763 | 255274 | 260669 | 264216
Pays de la Loire | Region | 2767163 | 2930398 | 3059112 | 3222061 | 3482594 | 3718512 | 3806461 | 3873096
Loire-Atlantique | Department | 934882 | 995822 | 1052466 | 1134551 | 1246967 | 1366358 | 1429272 | 1478101
Maine-et-Loire | Department | 629466 | 674997 | 705599 | 732657 | 770608 | 809055 | 818273 | 825241
Mayenne | Department | 261789 | 271784 | 278037 | 285338 | 300643 | 307940 | 307062 | 305870
Sarthe | Department | 490385 | 504768 | 513654 | 529851 | 556946 | 568445 | 566412 | 564588
Vendée | Department | 450641 | 483027 | 509356 | 539664 | 607430 | 666714 | 685442 | 699296
Provence - Alpes - Côte d'Azur | Region | 3675730 | 3965209 | 4257907 | 4506151 | 4864015 | 5007977 | 5081101 | 5131187
Alpes-de-Haute-Provence | Department | 112178 | 119068 | 130883 | 139561 | 156067 | 161799 | 164308 | 165582
Alpes-Maritimes | Department | 816681 | 881198 | 971829 | 1011326 | 1082465 | 1082440 | 1094283 | 1103555
Bouches-du-Rhône | Department | 1632974 | 1724199 | 1759371 | 1835719 | 1958926 | 2016622 | 2043110 | 2062499
Hautes-Alpes | Department | 97358 | 105070 | 113300 | 121419 | 132482 | 140916 | 141220 | 141059
Var | Department | 626093 | 708331 | 815449 | 898441 | 995934 | 1048652 | 1076711 | 1095564
Vaucluse | Department | 390446 | 427343 | 467075 | 499685 | 538141 | 557548 | 561469 | 562928
France | Republic | 52591584 | 54334871 | 56615155 | 58518395 | 61795238 | 64300821 | 65096768 | 65627454