| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use look-up table in Excel and enter into a "county" column, same
I would like to enter names and mailing addresses with column headings such
as fname,lname, address, city, state, zip and have Excel look up the county where the zip code is located and enter the county name into the same row in a "county" column. This has to be easier than I am making it. I assume I have to provide an array with columns such as "zip" and "county" for Excel to search. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use look-up table in Excel and enter into a "county" column, same
"hortguy510" wrote:
I would like to enter names and mailing addresses with column headings such as fname,lname, address, city, state, zip and have Excel look up the county where the zip code is located and enter the county name into the same row in a "county" column. This has to be easier than I am making it. I assume I have to provide an array with columns such as "zip" and "county" for Excel to search. Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use look-up table in Excel and enter into a "county" column, s
Thanks for the tip, Max. Deb's Contextures.com was just what this newbie
needed. I learned a lot. I recommend it to anyone for the basics. Chuck, R.D.O.H. (recently designated office hero) "Max" wrote: "hortguy510" wrote: I would like to enter names and mailing addresses with column headings such as fname,lname, address, city, state, zip and have Excel look up the county where the zip code is located and enter the county name into the same row in a "county" column. This has to be easier than I am making it. I assume I have to provide an array with columns such as "zip" and "county" for Excel to search. Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There's also some sample workbooks available for d/l & study -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use look-up table in Excel and enter into a "county" column, s
Glad to pass it on, Chuck!
Thanks for calling back .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "hortguy510" wrote: Thanks for the tip, Max. Deb's Contextures.com was just what this newbie needed. I learned a lot. I recommend it to anyone for the basics. Chuck, R.D.O.H. (recently designated office hero) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to enter negative amounts in the unit price column of excel | Excel Worksheet Functions | |||
| Automatic enter that returns you to column A in Excel | Excel Discussion (Misc queries) | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| How to enter a two line column heading in excel | New Users to Excel | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Linear Mode
