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

  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.
    0
    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?
      0
    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
      0
    3. tumankisial Author
      It's all good, I fixed the problem. Thank you very much.
      -4