When repeating city want zipcode to populate

[jrw - esq.]

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.

 

[Gord Dibben]

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

 

[CmK]

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