#1   Report Post  
esslingerdav
 
Posts: n/a
Default auto zip code

Good Day!
Novice excel user here. Will excel put the zip code into c1 depending on
the city and state inputted into a1 and b1? I have a rather large mailing
list to create and am looking for shortcuts in typing.

Thanks!
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

You need to create a master list of city/state and zip
codes and then use VLOOKUP to pull in the zip code. To
keep it simple, I would merge the city/state into one
column, separated by a comma. For example, on Sheet2:

A B
1 North Andover,MA 01845
2 Methuen,MA 01844
etc.

Then in C1, use:

=VLOOKUP(A1&","&B1,Sheet2!A:B,2,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
Good Day!
Novice excel user here. Will excel put the zip code

into c1 depending on
the city and state inputted into a1 and b1? I have a

rather large mailing
list to create and am looking for shortcuts in typing.

Thanks!
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM
Often-Used Code not working in a new Workbook Steve Excel Discussion (Misc queries) 2 December 16th 04 11:55 PM
Zip Code Macro Ken Wright Excel Worksheet Functions 0 December 9th 04 07:55 AM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM
Why can't my macro use Auto Filter when I told the Sheet Protecti. KC Rippstein Excel Worksheet Functions 1 October 28th 04 06:13 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"