Validy check in one coulmn to limit input options in another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to limit input options in one column depending on the entry in
another column (e.g. column 1 has input possibilities a, b, or c; if the
input is a, the options in column 2 should only be aa, aaa, or aaaa; if it is
b, only bb, bbb, or bbbb, etc. ...). How can I achieve this?
 
Try this:

Select B1

Data>Validation
Allow: Custom
Formula: =OR(B1=REPT(A1,1),B1=REPT(A1,2),B1=REPT(A1,3),B1=REPT(A1,4))


Am I on the right track here?

***********
Regards,
Ron

XL2002, WinXP-Pro
 

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

multiple dependent drop down lists 6
Duplicates are GOOD: How to find the most duplicated values? 1
In Cell Formula to mimic text to columns. 3
Adding data in columns based on criteria in more than one column.. 6
recursive relationship query question 8
Rating 5
Search between category limits 4
Fill cell colour based on input in another cell 2

Back
Top