Auto fill next column based on the selection from drop down

**sumesh83** · 09-17-2012, 08:42 AM

Hi All,

Here i would like to ask you a doubt.

I have an excel sheet. i have done data validation (List). I am able to get the data.

Here my problem is when i select one value or name i would like to get auto filled in the next column. This column also need data validation (list)

How can i do that. Please help me as soon as possible.

**NBVC** · 09-17-2012, 08:44 AM

Have a look here: Dependent Lists

**sumesh83** · 09-17-2012, 09:01 AM

Thank you for the quick reply. Please find attached excel.

Here i explain my need. in the sheet i have 3 column (Sl.NO, Team, Company)
When i select team as Red i should get company as general. If i select balck i would need all drop down to select the company. Can we do that?

**NBVC** · 09-17-2012, 09:12 AM

I don't under the sheet3 set up... how do you relate Red with General. Red is at top and General is at bottom of next column. Also, why is Black all teams? what about the other teams?

Did you read the article I linked you too? Did you understand it? Did you try it?

**sumesh83** · 09-17-2012, 09:22 AM

I read it. but it didn't help me. please ignore sheet 3. In this example Both column(Team and Company) having drop down list. I can select any value from both the cloumn. here i want automate only for team Red. All other teams i want to give the freedom to select from the drop down list. I hope you understood my need.

**NBVC** · 09-17-2012, 09:32 AM

Use a named range for the companies in Sheet2, call that range, Company.

Then use data validation formula in C2 and below cells of Sheet1:

=IF(B2="Red",INDEX(Company,6,1),INDEX(Company,1,1):INDEX(Company,5,1))