I need some help with a drop Box

[Shanemca]

Hello
I have a created a drop down box in Excel.
I have then used kutools to populate fields adjacent to the dropdown box. I need to create a new drop down from one of these populated fields. This box would simply allow you to choose one of two parameters.
I would be very grateful if someone could help me with a way to achieve this!
Regards
Shane

[Ursul]

Have a look at this example with 3 drop-downs. Note the formula used in the drop-down.

Cheers

DATA VALIDATION-3 Lists.xlsx

[FDibbins]

Shane, welcome to the forum

Hoe gaan dit daar in die kaap? SA expat here from PE and Klerksdorp, son lives in CT.

If yopu just want a DD with 2 options, you could just create a 2nd DD the same way you did the 1st 1. Even if the 2nd DD is related to the 1st, having only 2 choices - it would probably be simpler to just create it as another stand=alone