if statement and validation list

[mishkaPiska]

Hello,

I have a validation list at one cell and I want that the items in the list will change based on if statement.

How can I do it?

Thanks

[:) Sixthsense :)]

May be something like this...

=IF(A1=1,DefinedRange_1,DefinedRange_2)

[mishkaPiska]

what do you mean in "DefinedRanfe_1"?

[:) Sixthsense :)]

In Validation List
=IF(A1=1,H1:H10,I1:I10)

"DefinedRanfe_1 is a named range refers to H1:H10
"DefinedRanfe_2 is a named range refers to I1:I10