adding formula to data validation list dropdown

[Issa Saleh]

Is it possible to add a formula to data validation list dropdown.

Example:

I have two drop downs,

I want to add in the "second data validation drop down list" this formula:

=INDIRECT(A1)

If i use the type.formula i will loose the list functionality.

[Alex Harson James Henso]

Hi Issa,

 

XlsIO supports using formulas like =INDIRECT(A1) in data validation dropdown lists.

 

For more information, please refer to the following Knowledge Base article:

How to create a dependent dropdown list using XlsIO

 

Please feel free to reach out if you have any further questions or need assistance.

 

Regards,

Alex Harson James H