Why didn't you like the suggestions that you got the other day?

For others who may be posting, one of them suggested creating a table and using
data|validation and an =vlookup() formula.

And the other suggested using a formula to extract the monetary value from the
string in the picklist cell.

Ty wrote:

I posted this a few days ago, but Don't think I explained myself very well. Can anybody help me with this issue. I am trying to select an item from a pick list (Cell A1) to be inserted into another cell and be able to automatically copy the adjacent cell (A2) value to another cell.

Example:

This is the pick list

Cell A1 Cell A2
PAPER HOLDER - LEVEL I (CHROME) $2.80
TOWEL BAR - 24" LEVEL I (CHROME) $2.80
TOWEL BAR - 18" LEVEL I (CHROME) $2.80

Once I choose the item from Cell A1 to fill in another cell location, I want the adjacent price in Cell A2 to automatically fill in another cell location as well.

Thank you, Dave & Max for your suggestions. Maybe you or some other experienced Excel geniouses can help me out.

Thanks,
Ty

Ty /
31 min. 25 sec. ago

Header
Report as Spam

---
frmsrcurl: http://msgroups.net/microsoft.public.excel.misc/

--

Dave Peterson