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 | Statehood date | Statehood year | nicknames | ||
alabama | The yellowhammer state | ||||
alsaka | The last frontier | ||||
The Vlookup formulae is like this: | |||||
VLOOKUP(B546,SOCE!A37:B38,2,0) | |||||
1 | The lookup value shall be the state name(like Delware,Alaska etc..) | ||||
2 | The table array shall be from the the tab of Nicknames, you have to select all the area from | ||||
Col A to Col B in the Nicknames tab | |||||
3 | The column index number shall be 2 because the Nicknames is what you want and that is in | ||||
column no.2 or Col. B of Nicknames tab | |||||
4 | 0 is the the range lookup for exact function | ||||
Note:The above is just example, do not just copy the formula, just go through the above process | |||||
you will get the answer | |||||
Go back to the Statehood sheet. Add a column E called Nicknames. Use a VLOOKUP() function to add the nicknames from the...
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...