Can't choose correct DropList based on cell value

Should be simple, but can't work it out.

Have two DropLists which are independent, not linked to the other in any way.
Using row 2 as example. If A2 OR B2 OR C2 are "yes", then D2 should show DropList 1.
If A2, B2 and C2 all say "No", then Col D should show DropList 2

Any solutions, suggestions or alternatives welcome as ever.

Ochimus

Do you mean that you want to show all the values from the appropriate DropList down column D, or just the first item (or even just the text "DropList x") ?

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't bother trying to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Pete,

Appreciate the prompt response, and apologise that the explanation did not seem clear.

This is not about linking "Dependent" DropLists, but having a cell content drive the selection of different DropLists that are not "derivative" from each other.

As shown on the attached, Rows 2 - 8 have permutations of "Yes" or "No".

Cells D2 - D8 should contain the Stage 2 DropList in Col J, because at least one cell in Cols A - C of the row says "Yes".

D9, however, should contain the STAGE 1 DropList, as none of the cells in A9 - C9 say "Yes".

Look forward to hearing from you

Ochimus

How about using

Formula:

Please Login or Register  to view this content.

beaten2it

Apologies for delay in responding but was "In the Field" yesterday. Many thanks to both for "seeing the wood for the trees".

Works perfectly, so can now mark this as "Solved", and move on to the next challenge which I'm posting now!

Ochimus

Glad we could help & thanks for the feedback