Dependent Drop Down Lists Based On A Cell Value

Hi,

I'm looking for some help with dependent drop downs. I ideally need to create one based on the value of a cell that doesn't use a drop down to populate....but i cant seem to find any reference to this, only references to examples using multiple lists.

So what I am looking to do is simply have a drop down based on if a value in another cell is below or above 10,000. Is this possible? Or is there a better way to go about it?

Essentially I want to limit inputs based on the value of the cell being above or below 10k.

Thanks for the help!!

It would look something like this:

Formula:

Please Login or Register  to view this content.

where D1 contains the Value to be checked and RangeA and RangeB are Named Ranges.

You're welcome.