Excel Zip Code Match, Return City, State
Posted on 2013-06-26
On Sheet1 I have a Zip Code List in Column A. Sheet2 is a full database of all Zip Code information in the U.S. including City and State info.
I'm trying to get the City and State info from Sheet2, to show up in Sheet1 next to my Zip Code.
So basically I need to search Sheet2 and if it finds a match, take that City and State info and put it next to my Zip Code in Sheet1.
I'm assuming this is going to be a VLOOKUP formula, but I cannot get it to work. Right now my VLOOKUP to look up the City info looks like this:
4 is the column the City info is in. Am I not referencing it correctly?