I have a spreadsheet with cities and time zones. I have another with zip
codes, cities, states, and area codes. I would like to match up the time
zones with the cities in the second spreadsheet. I think the dlookup
function will do this, but I am not sure how to go about doing it - even
using the cities columns as a basis to match up on.

Any one out there who can help?

Thank you for your help and advice.

G