Excel Zip Code Match, Return City, State

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 an Excel newbie. I don't know how to use VLOOKUP so I tried using the Match and Index method I found on another forum. I could not get it to work.

I've uploaded the excel worksheet.

Can anyone spot the #N/A error I'm getting?

Data in column A Sheet1 is TEXT but NUMBER (General) in Sheet2

Convert Sheet1 column A to GENERAL.

Extend named ranges to B1:B50000

Your formulas will work but there are many missing Zip Codes!!!