IF Statement
 

I need a solution for the example below please,

A1 could hold value 9.5, 7.5 or 0
If A1 =9.5 then I need A2 to show a drop down validation list which is also
at V1.
If A1=7.5 then I need A2 to show a drop down validation list which is also
at V2.
If A1=0 then I need A2 to show a drop down validation list which is also at
V3.

Basically I need to copy an exsisting validation list from V1,2 or 3
depending on the value of A1.

Any help is appriciated.

IF Statement
 

one way:

in B1:

=IF(A1=9.5,"List1",IF(A1=7.5,"List2","List3"))

where List1 to List3 are your lists (named ranges) at V1 to V3

in A2: Data Validation==List==Source: =INDIRECT(B1)

HTH

"LaDdIe" wrote:

I need a solution for the example below please,

A1 could hold value 9.5, 7.5 or 0
If A1 =9.5 then I need A2 to show a drop down validation list which is also
at V1.
If A1=7.5 then I need A2 to show a drop down validation list which is also
at V2.
If A1=0 then I need A2 to show a drop down validation list which is also at
V3.

Basically I need to copy an exsisting validation list from V1,2 or 3
depending on the value of A1.

Any help is appriciated.

IF Statement
 

THANK YOU x1000000000000000000000000000000.

"Toppers" wrote:

one way:

in B1:

=IF(A1=9.5,"List1",IF(A1=7.5,"List2","List3"))

where List1 to List3 are your lists (named ranges) at V1 to V3

in A2: Data Validation==List==Source: =INDIRECT(B1)

HTH

"LaDdIe" wrote:

I need a solution for the example below please,

A1 could hold value 9.5, 7.5 or 0
If A1 =9.5 then I need A2 to show a drop down validation list which is also
at V1.
If A1=7.5 then I need A2 to show a drop down validation list which is also
at V2.
If A1=0 then I need A2 to show a drop down validation list which is also at
V3.

Basically I need to copy an exsisting validation list from V1,2 or 3
depending on the value of A1.

Any help is appriciated.