Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zip Code/Service Area help
In one spreadsheet, I have a list of zip codes in Column A. In a second
worksheet I have a list of zip codes in Column A and a Service Area name in Column B. In my first spreadsheet I want to fill in the service area name from the second spreadsheet that corresponds to the zip code. is there some function that will allow me to do that in excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zip Code/Service Area help
The VLOOKUP() function is what you want to use in column B on the first
worksheet. Lets say that on the SECOND sheet your list of zip codes (and service areas) goes from row 2 down to row 141. I will assume that the first zip code on the first sheet is also in row 2. In B2 on the first sheet enter this formula: =VLOOKUP(A2,'Sheet2'!$A$2:$B$141,2,0) You'll need to change 'Sheet2' to use the actual name of that second sheet. From this point, you can fill that formula on down the column on the first sheet and it will do the job for you. CAVEAT: If a zip code is listed more than one time on the second sheet, the formula will always return the service area associated with the first occurance of that zip code on the second sheet. Hope this helps some. "BStacy" wrote: In one spreadsheet, I have a list of zip codes in Column A. In a second worksheet I have a list of zip codes in Column A and a Service Area name in Column B. In my first spreadsheet I want to fill in the service area name from the second spreadsheet that corresponds to the zip code. is there some function that will allow me to do that in excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Zip Code/Service Area help
Yes.
See VLOOKUP in Excel Help -- Gary''s Student - gsnu200842 "BStacy" wrote: In one spreadsheet, I have a list of zip codes in Column A. In a second worksheet I have a list of zip codes in Column A and a Service Area name in Column B. In my first spreadsheet I want to fill in the service area name from the second spreadsheet that corresponds to the zip code. is there some function that will allow me to do that in excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
Phone with/without area code format | Excel Worksheet Functions | |||
Can you call a Web Service from Excel 2007 without writing code? | Excel Discussion (Misc queries) | |||
adding a phone area code that is not there | Excel Discussion (Misc queries) | |||
Integration/area under a curve VBA code? | Excel Discussion (Misc queries) |