Drop Down Lookup Return Value From Another Cell

  • Thread starter Stephen Moeller
  • Start date
S

Stephen Moeller

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lookup Return Value From Another Cell 2
Drop-down list and error message 1
Data Validation and drop-down list using IF, AND and what else? 8
Excel Excel: How do I put a formula in a drop down list 11
lookup and return column number 2
Drop Down List 7
Select name from drop down and return associated value 6
Filter out rows based on the value of a cell 4

Top