Validation Options with option List
 

Good morning!


i have set up an validation list option in Excel so i can choose what
option to pick. For example, i can choose test1, test2 and/or test3.
But what i want to try to do is when i choose one of the options
test1,test2 and/or test3 i want for those options different fields like
for example:

Test1

this is the text of data for test1


When i choose the option Test2 i want the text or data cleared for
test1 and see the text for option 2. I hope you can help me with this
problem, thanks in advanced!

Edo


--
EdoZwart
------------------------------------------------------------------------
EdoZwart's Profile: http://www.excelforum.com/member.php...o&userid=30000
View this thread: http://www.excelforum.com/showthread...hreadid=496878

Validation Options with option List
 

Could you not just add a simple IF test in an adjoining cell

=IF(H1="test1","this is the text for test1", IF(H1 = "test2", ...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"EdoZwart" wrote in
message ...

Good morning!


i have set up an validation list option in Excel so i can choose what
option to pick. For example, i can choose test1, test2 and/or test3.
But what i want to try to do is when i choose one of the options
test1,test2 and/or test3 i want for those options different fields like
for example:

Test1

this is the text of data for test1


When i choose the option Test2 i want the text or data cleared for
test1 and see the text for option 2. I hope you can help me with this
problem, thanks in advanced!

Edo


--
EdoZwart
------------------------------------------------------------------------
EdoZwart's Profile:
http://www.excelforum.com/member.php...o&userid=30000
View this thread: http://www.excelforum.com/showthread...hreadid=496878

Validation Options with option List
 

If you are talking about actual tests (e.g. test1 has several questions,
test2 has several questions and so on) you can do this. Let's say your tests
are on sheet 1 and your validation is on sheet 2. On sheet 1, insert a
column to the left of the questions. In the new column, next to the first
question of test1, type "test11", beside the second question of test1, type
"test12" and do this for the rest of the questions. When you get to the
test2 questions, type "test21"..."test22"... "test23", etc. Now, go
to sheet 2 and move your validation box to cell B1. In column A, on the row
where you want the first question to be, type =$B$1&1 Where you want the
second question to be, type =$B$1&2 Do this down the page for as many
questions as you have in each test. In column B, where you want the first
question to be, type =VLOOKUP(A2,Sheet1!$A$1:$B$50,2,FALSE) The array
[A1:B50] needs to cover all three tests on sheet 1. You can then copy this
formula and paste it where you want question 2... and so on down the page.
Now when you change the validation in B1 to "test2", all of the test2
questions will appear... change it to test3 and all of the test3 questions
will appear.

Hope this helps.

"Bob Phillips" wrote:

Could you not just add a simple IF test in an adjoining cell

=IF(H1="test1","this is the text for test1", IF(H1 = "test2", ...

--

HTH

RP
(remove nothere from the email address if mailing direct)


"EdoZwart" wrote in
message ...

Good morning!


i have set up an validation list option in Excel so i can choose what
option to pick. For example, i can choose test1, test2 and/or test3.
But what i want to try to do is when i choose one of the options
test1,test2 and/or test3 i want for those options different fields like
for example:

Test1

this is the text of data for test1


When i choose the option Test2 i want the text or data cleared for
test1 and see the text for option 2. I hope you can help me with this
problem, thanks in advanced!

Edo


--
EdoZwart
------------------------------------------------------------------------
EdoZwart's Profile:
http://www.excelforum.com/member.php...o&userid=30000
View this thread: http://www.excelforum.com/showthread...hreadid=496878