Dependent Drop-down List Shifted To The Right

[ajocius]

I'm having a problem with dependent drop down lists. On the internet there are a bunch of examples, but each example has the data column right next to the dependent list. In my use of dependent drop-down lists my independent list is in column D and my dependent list is in column F. Can someone show me how to create the dependent list which isn't adjacent to the independent list?

[JBeaucaire]

The column is irrelevant, the formula used to activate the Dependent list is usually looking to left to SOME column and noting that cell in the formula. What Dependent Validation for an adjacent cell have you tried and gotten working? You should be able to take that EXACT same formula and move it over one column, no changes at all as you enter it, and it should work exactly the same as when you had the columns adjacent.

Show us what you've tried so far if you still can't get it, but if you have found and seen how adjacent columns work, there's fundamentally no difference, put the same formula you would have to look ONE cell to the left over as many columns as you wish, just make sure the formula you enter is referring to the dependent column.

[FDibbins]

Dependent drop-downs are based on named ranges, using =range-name. As such, the location of that range should nor affect how the DD works?

Maybe you should upload a sample workbook for us to take a look at? (No sensitive info)

[ajocius]

OK, I kind of got it working. It has two flaws that I can't seem to fix. The first being it only see one value in the dependent side of the list. Second, I want to be able to change the contents of a cell in the dependent cell. For example I want the user to take V,currLIM,PS1_MUX,tol,ON,OV
which they can select and then write 5,01,PS1_MUX,.1,ON,7. With these two fixes I have a workable spreadsheet. See attached.

[JBeaucaire]

You really only need 3 named ranges to get this to work.

1) Click on F2 before you edit these formulas

2) Range formulas:

CODE: =Lists!$A$2:INDEX(Lists!$A:$A, COUNTA(Lists!$A:$A))

AnchorCell: =Lists!$A$1

MyList: =OFFSET(AnchorCell, 1, MATCH(Setup!$D2, Lists!$1:$1, 0)-1, COUNTA(OFFSET(AnchorCell, 1, MATCH(Setup!$D2, Lists!$1:$1, 0)-1, 100, )), )

[ajocius]

Fantastic, its almost there. I can select each of the two cells in their respective columns. I want to be able to change the contents of the contents in column D. Almost there

[ajocius]

Oops, I meant to say change the contents in Column F. Sorry.

[JBeaucaire]

What is stopping you? Clicking on any cell in column F should allow you to edit them. The only constraint is you have to select from the options provided.

[ajocius]

Perfect. This is solved. Great job and now I can use to assist a whole bunch of engineers. Thank you very much.

[ajocius]

[SOLVED] Notch one for JBeaucaire.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.