i want to be able to input a zipcode in a cell, and then have the city state and country be found from a website that is spitting out the data in text form in the window
http://zip.elevenbasetwo.com/v2/US/90210
check out what its spitting out please
i need it to change the zipcode at the end of website automatically and grab the following data that spits out
{"city": "Beverly Hills", "state": "California", "country": "US"}
there is an example of my workbook attached, please review
im open to other ideas as well
Bookmarks