| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return value from a list
It must be Monday. My brain isn't working this morning.
I have a list of states and the region that they are in. When I have a customer, I want to simply type in the state and it will automatically bring up their correct region. Currently, my region data is by row: PACIFIC WEST AZ CA HI NM NV EAST CT DE FL GA Can you help me come up with the correct value that will return "Pacific West" when the value of CA is entered? Thank you, Peanut |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return a list dependent upon the selection of a preceeding list | Excel Worksheet Functions | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| return a list | Excel Worksheet Functions | |||
| return a list | Excel Worksheet Functions | |||
| look up a list and return a value | Excel Worksheet Functions | |||
Threaded Mode
