Auto Install

[charliep]

Auto install, I'm working with a dropdown box with a list of 10 different items, in column B. My question is, Can I create a description in column C depending on what I selected in Column B.

[Don]

Hi and welcome to the forum!

You would need to use a vlookup function for this. You could have a table containing the descriptions somewhere in the spreadsheet and then put the vlookup function that references that table in the cell in column c.

Using the vlookup function can be kind of confusing if you've never done it before, so here is a video tutorial that will walk you through how to use the vlookup function:

http://www.youtube.com/watch?v=CnP9GPkvXQE

hope this helps

[Sisyphus]

Hi,
I feel I could give a better answer if I would better understand your question. A workbook to look at would be very helpful!
I take it that column B is in the worksheet, not the drop down.
I take it that the drop down is a validation list.
I now presume that you want a validation drop down in column C that is loaded in dependence of what was selected in Column B.
Having come this far I have two questions.
1. Are my suppositions correct?
2. Are you trying to do all that without the use of code?
Have a great day?