Pick List Problem

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
 
D

Douglas J. Steele

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.
 

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

Excel Excel Pick List Problem 0
Pick List Problem 7
Problem with Pick List associated cell 2
Pick List Problem 0
Pick from drop-down list gives empty or erroneous result 6
Can you use one pull down menu to call a list for adjacent cell? 1
Array Summation in Excel 0
formula to search and find item sheet1 copy to sheet 2 1

Top