i need to search a column in my database file for zipcode and provide data elsewere

[nate02167]

i have a excel file that has all US zipcodes and what city and state and country there in (database)

i need to reference this "database" in my address workbook, witch has columns

zipcode state city country


(example file provided)

so when i type or copy a zip code into that column i need the macro/if-statement to reference my

"database file"

ie

if it finds 90210 in the database i want it to return : CA, BEVERLY HILLS, USA

AND PLACE THE DATE IN SEPERATE CELLS

[Olly]

A VLOOKUP will work against your Zip data. See attachment, I've put the necessary formulae in cells F3:F5.

zipdata.xlsx