| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Lookup Return Value From Another Cell
Greetings!
I would like to have a drop down pick list that returns the value from an adjacent cell instead of the one picked. For example, I have a list of Units of Measures in one column and their abbreviations in an adjacent column (i.e. "hundred weight" in cell b2 and "CWT" in cell a2) I would like to have the drop down list displaying the long description in column B to pick from but return the abbreviation from column A. Can not figure it out, what am I missing? SM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drop Down Lookup Return Value From Another Cell
Not supported in Data validation dropdowns.
Using something else? Elaborate? What type of control, where is it located, how is it populated? -- Regards, Tom Ogilvy "Stephen Moeller" wrote: Greetings! I would like to have a drop down pick list that returns the value from an adjacent cell instead of the one picked. For example, I have a list of Units of Measures in one column and their abbreviations in an adjacent column (i.e. "hundred weight" in cell b2 and "CWT" in cell a2) I would like to have the drop down list displaying the long description in column B to pick from but return the abbreviation from column A. Can not figure it out, what am I missing? SM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel when i hit return, the cursor does not drop down 1 cell | Excel Discussion (Misc queries) | |||
| Lookup, and Return Cell Address | Excel Worksheet Functions | |||
| Lookup a value and return its cell reference instead of the value | Excel Discussion (Misc queries) | |||
| V Lookup and return cell address | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
Hybrid Mode
