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. plz just give me 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 State Nickname Alabama The Yellowhammer State Alaska The Last Frontier Arizona The Grand Canyon State Arkansas The Natural State California The Golden State Colorado The Centennial State Connecticut The Constitution State Delaware The First State Florida The Sunshine State Georgia The Peach State Hawaii The Aloha State Idaho The Gem State Illinois The Prairie State Indiana The Hoosier State lowa The Hawkeye State Kansas The Sunflower State Kentucky The Bluegrass State Louisiana The Pelican State Maine The Pine Tree State Maryland The Old Line State Massachusetts The Bay State Michigan The Great Lakes State Minnesota The North Star State Mississippi The Magnolia State Missouri The Show Me State Montana The Treasure State Nebraska The Cornhusker State Nevada The Silver State New Hampshire The Granite State New Jersey The Garden State New Mexico The Land of Enchantment New York The Empire State North Carolina The Tar Heel State North Dakota The Peace Garden State Ohio The Buckeye State Oklahoma The Sooner State Oregon The Beaver State Pennsylvania The Keystone State Nicknames Capitals Statehood +
