Small Database in Excel

[suumitsiingh]

Dear Friends,
I am working on small database for US Customers, where one of the retailer wants to add customer address data in Excel. The entries are more than millions.
I am looking for a solution where, we select zip code, then related City, State name should add to to the cell and then we can add Customer Name, Mail Id and Postal Address.

Is there any way to do so in excel sheets, I working on 2010 version.

Regards
Sumeet

 

[Robert Mika]

Dear Friends,
I am working on small database for US Customers, where one of the retailer wants to add customer address data in Excel. The entries are more than millions.
I am looking for a solution where, we select zip code, then related City, State name should add to to the cell and then we can add Customer Name, Mail Id and Postal Address.

Is there any way to do so in excel sheets, I working on 2010 version.

Regards
Sumeet

Hello and welcome to MrExcel.
Milion is not small number - I would consider Access for this.