Question

Go back to the Statehood sheet. Add a column E called Nicknames. Use a VLOOKUP() function to add the nicknames from the nicknames sheet into column E of the statehood sheet. Please just give the vlookup function to type in

State # nicknames State Delaware Pennsylvania New Jersey Georgia Connecticut Massachusetts Maryland South Carolina New Hampshire Virginia New York North Carolina Rhode Island Vermont Kentucky Tennessee Ohio Louisiana Indiana Mississippi Illinois Alabama Maine Missouri Arkansas Michigan Florida Texas lowa Wisconsin California Minnesota Oregon Kansas West Virginia Nevada Nebraska Colorado Statehood Date December 7, 1787 December 12, 1787 December 18, 1787 January 2, 1788 January 9, 1788 February 6, 1788 April 28, 1788 May 23, 1788 June 21, 1788 June 25, 1788 July 26, 1788 November 21, 1789 May 29, 1790 March 4, 1791 June 1, 1792 June 1, 1796 March 1, 1803 April 30, 1812 December 11, 1816 December 10, 1817 December 3, 1818 December 14, 1819 March 15, 1820 August 10, 1821 June 15, 1836 January 26, 1837 March 3, 1845 December 29, 1845 December 28, 1846 May 29, 1848 September 9, 1850 May 11, 1858 February 14, 1859 January 29, 1861 June 20, 1863 October 31, 1864 March 1, 1867 August 1, 1876 Statehood Year 1787 1787 1787 1788 1788 1788 1788 1788 1788 1788 1788 1789 1790 1791 1792 1796 1803 1812 1816 1817 1818 1819 1820 1821 1836 1837 1845 1845 1846 1848 1850 1858 1859 1861 1863 1864 1867 1876

Answer 1

The Vlookup function to type in column E2 of Sheet Statehood is =Vlookup(A2,Nicknames!$A$2:$B$39,2,false). Just copy the formula in column E2 and paste from column E3 to E39.