drop down box event changes in different cells

T

Tulwean

Joined
Jul 12, 2010
Messages
1
Reaction score
0
hopefully this will be simple

i have a list of items in collum A, Prices in C(B is used for conversion calculations and is hidden)

In A21 i would like a dropdown/combo box or what ever with the list of items(i figured that one out). In B21 I want it to automaticly change to the price of the selected item.

I hope some one can help, ive been searching for 3 days and i cant find anything that helps.
 

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

Showing information according to a selection in a drop down box 2
Drop down list selections creating values in adjoining cell 1
excel 2003 drop-down box color changes how 2
Remove blank cells from data validation drop down box 3
sizing in Drop Down lists 6
In excell 2003, increasing number of items shown in drop down list 1
drop down box issues 1
Drop down box issue 2

Top