For the reference sheet on page 2, you have to have the zip code, or a copy of the zip code column, to the left of the city and state. It wil find the first match, so if multiple cities share the same zip code, you may get the incorrect one. The first formula looks up the city, the second one the state. attach_file Example_Vlookup.xlsx 10.2 KB. Batch or bulk geocode a csv, tsv, or Excel spreadsheet of US and Canadian addresses, ... or zip codes into latitude/longitude and reverse geocode latitude/longitude into addresses Pricing. Customers. Financial Services Real ... System Status API Documentation Guides Tutorials Report Address Issue Single Address Lookup Contact Support.