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

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