| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Picking Region Data from State Information
Using Excel 2003 on a PC, I want to do the following:
I work for a nationwide company that breaks the states into 11 regions. I want my spreadsheet to automatically calculate which region a state is in (meaning, for example, I put in "Joe Schmo" lives in "UT" and the worksheet inputs "7" in the REGION column). What would be the most parsimonious means of doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| Conditional Vlookup - Cherry picking information from the table ar | Excel Discussion (Misc queries) | |||
| mail merge not picking up state for address labels from excel spr | Charts and Charting in Excel | |||
| Keep cell reference when picking up information from another database | Excel Programming | |||
| Keep cell reference when picking up information from another database | Excel Programming | |||
Threaded Mode
