Use VLOOKUP to add the appropriate population values from j to column B AВDGJKLMCases,Cases,Deaths,Deaths,Use VLOOKUP to add the appropriate PopulationNamePopulation Cases, totalper 1Mlast 7 daystotalper 1MValues from Column J to Column BUSACountryPopulation 202012,939,66639,0926,8061,150,654262,736794IndiaChina1,439,323,7761,380,00,3859,392,919297,113136,69699BrazilIndia6,238,35029,349218,186171,974809RussiaUSA331,002,651273,523,6152,269,31615,550179,98739,527271lindonesiaFrance2,169,81133,24280,45851,767793PakistanSpainUnited Kingdom220,892,3401,628,20834,82442,52844,668955Brazil212,559,417206,139,5891,605,17623,645111,78958,03054,363855Italy1,564,532Nigeria25,876184,001.899Bangladesh164,689,383P Argentina1 Colombia2 Mexicoa Germany1,407,27731,13748,23538,216846Russia145,934,462128,932,7531,290,51057,06664,70625,36236,214712Мexico1,090,6758,459104,873813Japan126,476,4611,042,70012,445124,43116,123192EthiopiaPhilippines4 Poland114,963,58825,72529,065973,593130,11816,7464425 Peru109,581,078958,32412,23735,8391,087Egypt102,334,40497,338,5796 Iran935,79911,14194,491.47,486565Vietnam7 South Africa8 Ukraine9 Belgiumo Chile785,139722,67913,23819,73021,439361CongoTurkey89,561,40384,339,06716,52597,93512,21316,461279574,35249,55713,3001,420Iran83,992,949ce1 Iraq22 Indonesia23 Czechia24 Netherlands25 Turkey548,94128,7169,79815,32222 792 04783,783,942802548,821527,999GermanyThailandUnited Kingdon13,64515,26612,20030369,799,97867,886,01165,273,51160,461,82659,734,21859,308,6901,93034,69116,6466127,89934,017518,64948,4318,054752France512,69529,9219,313544Italy487,9125,78547,10713,373159Tanzania26 Romania465,98224,22253,17411,045574South Africa27 Bangladesh28 Philippines29 Pakistan460,6192,79715,3386,58040Myanmar54,409,800427,7973,90410,9458,3337653,771,29651,269,18550,882,89146,754,778KenyaSouth Korea392,3561,77620,8487,9423630 Canada359,0649,51438,34511,894315Colombia31 Saudi Arabia356,91110,2521,8775,870169Spain32 Morocco349,6889,47428,7265,739155Uganda45,741,00733 Israel332 19238 379л 0712821227

VLOOKUP is an abbreviation for 'Vertical Lookup.' It's a function that tells Excel to look for a…

49,557 B. D F G Cases, Cases, Deaths, Deaths. Use VLOOKUP to add the appropriate Population Values from Column J to Column B Name Population Cases, total last 7 days per 1M total per 1M USA Country Population 2020 39,092 6,806 12,939,666 1,150,654 262,736 794 India China 1,439,323,776 9,392,919 297,113 136,696 99 Brazil India 1,380,00,385 6,238,350 29,349 218,186 171,974 809 Russia USA 331,002,651 2,269,316 179,987 80,458 42,528 15,550 39,527 271 lindonesia Pakistan France 273,523,615 2,169,811 33,242 51,767 793 Spain United Kingdom Italy Argentina Colombia 220,892,340 212,559,417 1,628,208 34,824 44,668 955 Brazil 1,605,176 23,645 25,876 111,789 58,030 855 Nigeria Bangladesh 206,139,589 1,564,532 184,001 54,363 899 164,689,383 1,407,277 31,137 48,235 38,216 846 Russia 145,934,462 1,290,510 1,090,675 25,362 57,066 36,214 712 Mexico Mexico 128,932,753 8,459 64,706 104,873 813 Jарan Ethiopia Philippines Germany 126,476,461 1,042,700 973,593 958,324 12,445 124,431 16,123 192 114,963,588 109,581,078 102,334,404 Poland 25,725 130,118 16,746 35,839 442 Peru 29,065 12,237 1,087 Egypt Iran 935,799 11,141 94,491 47,486 565 Vietnam 97,338,579 South Africa 785,139 722,679 574,352 13,238 19,730 21,439 361 Congo Turkey 89,561,403 Ukraine 16,525 97,935 12,213 279 84,339,067 Belgium 13,300 9,798 49,557 16,461 1.420 Iran 83,992,949 Chile 548,941 28,716 15,322 802 Germany Thailand United Kingdon 83,783,942 Iraq eIndonesia s Czechia Netherlands 5 Turkey S Romania - Bangladesh 3 Philippines 548,821 13,645 15,266 12,200 303 69,799,978 527,999 1,930 34,691 16,646 61 67,886,011 518,649 48,431 27,899 8,054 752 France 65,273,511 512,695 29.921 34,017 9,313 544 Italy 487,912 465,982 60,461,826 59,734,218 5,785 47,107 13,373 159 24,222 2,797 Tanzania South Africa 53,174 11,045 574 59,308,690 460,619 15,338 6,580 40 Myanmar 54,409,800 427,797 3,904 10,945 8,333 76 Kenya 53,771,296 20,848 38,345 1,877 7,942 9 Pakistan o Canada 1 Saudi Arabia 392,356 1,776 36 South Korea Colombia 51,269,185 359,064 356,911 11,894 5,870 9,514 315 50,882,891 10,252 169 Spain Uganda 46,754,778 2 Morocco 349,688 9,474 28,726 5,739 155 45.741.007