Drop-down list or concrete valuedepending on the value in another cell

Can you elaborate on what you mean by depending on a value in another cell? As in you want the dropdown list categories to update based on an IF statement?

Hello,

can you explain in a bit more detail? What value? If that value depends on another cell, you could put a formula into the cell:

=If(A1="the condition","concrete value","please select from the drop down")

Then add data validation to the cell with a list of drop down choices.

Once the user has selected a value from the drop down, this will overwrite the formula, though. If the value in A1 changes, the drop-down cell will not get the "concrete" value back. That can only be done with VBA.

But maybe there is another way to do what you want to achieve. If you post a sample file and explain a bit more, we may be able to work out a different scenario.

cheers, teylyn

An example of what you're looking for is attached. It may not be the most eloquent, and I'm sure someone else has a cleaner method, but it works nonetheless.

Hope this helps!