This is my problem:

Spreadsheet A: I have a spreadsheet with names, addresses, phone numbers, etc., but no zip codes.

Spreadsheet B: I have another spreadsheet with all the same information, plus the zip codes.

I need to somehow match the addresses of Spreadsheet A with the zip codes of Spreadsheet B.

Let me rephrase: What kind of formula can I put into my empty zip code cell that will match the address in Spreadsheet A with the address in Spreadsheet B, and pull the zip code information from Spreadsheet B into Spreadsheet A?

Thanks!