View original (French)

Discredited source

Solved
tumankisial Posted messages 27 Status Member -  
tumankisial Posted messages 27 Status Member -
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 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    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 Posted messages 27 Status Member
       
      “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 Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      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 Posted messages 27 Status Member
       
      It's all good, I fixed the problem. Thank you very much.
      -4