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.