But I am do a function like this - if column A equals Hendersonville, TN,
then I want Excel to automatically enter the zip of 37075.

How would I write that? Thanks for the help.

If you only had a couple of choices for the city/state, you could use a few
=If()'s.

But after even a few entries, this becomes difficult.

I'd create a new sheet and put the city/states in column A and the zips in
column B.

Then I could use =vlookup() to retrieve the zipcodes.

=if(a1="","",vlookup(a1,sheet2!a:b,2,false)

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://contextures.com/xlFunctions02.html#Trouble



April wrote:

But I am do a function like this - if column A equals Hendersonville, TN,
then I want Excel to automatically enter the zip of 37075.

How would I write that? Thanks for the help.

--

Dave Peterson

whether both of the data (i.e.) Name and zip is present in somewhere of your
workbook?

Like this
Hendersonville, TN 37075

--------------------
(Ms-Exl-Learner)
--------------------



"April" wrote:

But I am do a function like this - if column A equals Hendersonville, TN,
then I want Excel to automatically enter the zip of 37075.

How would I write that? Thanks for the help.

April wrote:
But I am do a function like this - if column A equals Hendersonville, TN,
then I want Excel to automatically enter the zip of 37075.

How would I write that? Thanks for the help.


But Hendersonville has two zip codes...37075 and 37077. And what about
Nashville, which lists 37201 through 37222, 37224, 37227 through 37230, 37232
and 37234 through 37250 for a total of 45 options.