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/