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

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?

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

Try this:

Select B1

DataValidation
Allow: Custom
Formula: =OR(B1=REPT(A1,1),B1=REPT(A1,2),B1=REPT(A1,3),B1=R EPT(A1,4))


Am I on the right track here?

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

XL2002, WinXP-Pro


"Katja" wrote:

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?

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

Debra Dalgliesh has an excellent explanation

See
http://www.contextures.com/xlDataVal02.html

"Katja" wrote:

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?