For your second question

Maybe you can do a VLookup on the zip code.