Pick List Problem

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

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.

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

Thanks,
Ty
 
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting to a newsgroup related to Excel.
 
Back
Top