Hi,

I try to find a solution (with or without macro) to assign different ranges named "Failure_C..." in a data validation source depending on the value of another data validation list (32 values called)

I started in the Data Validation List Source to fill in IF function but 32 inputs are not accepted and too much caracters in the source.

The formula is starting like that: =IF(A57=$M$78,Failure_C01,IF(A57=$M$79,Failure_C02,IF(A57=$M$80,Failure_C03,IF(A57=$M$81,Failure_C04,IF(A57=$M$82,Failure_C05,IF(A57=$M$83,Failure_C06,IF(A57=$M$84,Failure_C07............

Can you help me ?

Thanks.