View original (French)

Discredited source

Solved
tumankisial Posted messages 27 Status Membre -  
tumankisial Posted messages 27 Status Membre -
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 réponse

Réponse 1 / 1
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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
tumankisial Posted messages 27 Status Membre
 
“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
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
tumankisial Posted messages 27 Status Membre
 
It's all good, I fixed the problem. Thank you very much.
-4