HELP: Data > Validation ---List ----Formula

  • Thread starter Thread starter amit
  • Start date Start date
A

amit

I am trying to generate "Drop down list" using formula.

The path I am using is :

Data > Validation ---List ----Formula

It seems there is limitation on no. of characters, which could be
typed in this FORMULA field.

Can someone help me in generating the list using someother technic.

Thanks in advance for your replies.
 
Perhaps you could enter the formula in an adjacent cell, then refer to
that cell in the data validation formula box.
 
Debra,

Thanks a lot for your reply.

I tried that but it doesn't help for list of values.

More specifically:

I have 12 columns, each containing a list of 100 values (1 value in a
cell).

Based on the value of a cell, different from the cells mentioned
above, in range of 1 to 12 one of the list is to be selected in Drop
down list (using Data > Validation ---List ----Formula).

The above mentioned field at the end of path allows only 8
IF-THEN-ELSE type statements.

I tried using Index, Match, address functions etc. but I am not able
to get the solution.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula and Data Validation parallely 1
Dependent drop down dynamic range formula, off sheet. 7
Lookup Function for Data Validation 2
Data validation lists help? 6
Filtered Validation List 4
Data Validation lists update orginal cell with list update 3
a data validation list that contains a list of named ranges - not alist from a named range 1
data validation drop down list format 1

Back
Top