Drop Down Lookup Return Value From Another Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen Moeller - 08 Nov 2006 16:41 GMT

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 to this Message

Debra Dalgleish - 08 Nov 2006 17:55 GMT

You can do this with data validation and programming. There's a sample
file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0005 - Data Validation "Columns"'

> 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
[quoted text clipped - 5 lines]
> description in column B to pick from but return the abbreviation from
> column A. Can not figure it out, what am I missing?

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message