I am a novice at using functions

  • Thread starter Thread starter April
  • Start date Start date
A

April

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
 
whether both of the data (i.e.) Name and zip is present in somewhere of your
workbook?

Like this
Hendersonville, TN 37075
 
April said:
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.
Click to expand...


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.
 
Back
Top