| 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. |
| 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 | |||
Threaded Mode
