When repeating city want zipcode to populate
 

Making a data base of mailing addresses. Is there a formula to use to get a
zipcode to populate in a cell when a city and state is entered in two other
cells?
Thanks.

When repeating city want zipcode to populate
 

See help on VLOOKUP function.

Or go here for excellent help and an example workbook.

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 08:05:32 -0800, jrw - esq. <jrw -
wrote:

Making a data base of mailing addresses. Is there a formula to use to get a
zipcode to populate in a cell when a city and state is entered in two other
cells?
Thanks.

When repeating city want zipcode to populate
 

Yeah its called vlookup if u email the i will do it for ya


"jrw - esq." wrote:

Making a data base of mailing addresses. Is there a formula to use to get a
zipcode to populate in a cell when a city and state is entered in two other
cells?
Thanks.