The following is a selection from a spreadsheet: A B C 1 Country Population in 2020 (millions) Growth in population 2000-2020 2 China 1,439,323,776 13.4% 3 India 1,380,004,385 37.1% 4 United States 331,002,651 17.3% 5 Indonesia 273,523,615 27.7% 6 Pakistan 220,892,340 44.9% 7 Brazil 212,559,417 21.9% 8 Nigeria 206,139,589 66.3% 9 Bangladesh 164,689,383 27.9% 10 Russia 145,934,462 -0.8% 3 To search for the population of Nigeria, what is the correct VLOOKUP syntax?
a. =VLOOKUP(Nigeria, A2,C10, 2, true) b. =VLOOKUP(Nigeria, A2:C10, 3, true) c. =VLOOKUP("Nigeria", A2:C10, 2, false) d. =VLOOKUP(Nigeria, A2:C10, 3, false)

Answer :

Other Questions