View original (French)

Discredited source

Solved
tumankisial -  
Hello.
I am trying to create a cascading dropdown list in Excel. I am writing the INDIRECT() formula, and when I try to validate, a message says "the source is recognized as erroneous, do you want to continue?" I accept, and afterwards I cannot expand the list. Do you know what this is due to? Do you have any solutions?
Thank you in advance.

1 answer

  • Votes
  • Date
  • Descending date
  1. Mike-31
    Hello,

    I assume you are correctly using the syntax by properly referencing the cell containing your validation list
    =INDIRECT(address of your cell)
    for example, if your validation is in A1
    =INDIRECT(A1)

    then check that the name selected in your first validation is exactly the same as the name in your second range that supplies your validation
    --
    Best,
    Mike-31

    A period of failure is a perfect moment to sow the seeds of knowledge.
    1. tumankisial Author
      “Then check that the name selected in your first validation is exactly the same as the name in your second range that provides your validation.”

      I didn't quite understand this sentence?
    2. Vaucluse Contributor
      Mike means that if you use validation via list and

      =INDIRECT(CelluleX)
      CelluleX must contain exactly the label of the field name you want to display in the menu

      But what exactly do you have in INDIRECT(?????)

      Regards
    3. tumankisial Author
      It's all good, I fixed the problem. Thank you very much.