Validation Options with option List

EdoZwart · #1 12-30-2005, 03:11 AM

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

#2 12-30-2005, 05:55 AM

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" <EdoZwart.20ufyy_1135930501.2578@excelforum-nospam.com> wrote in
message news:EdoZwart.20ufyy_1135930501.2578@excelforum-nospam.com...
>
> 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
>

#3 12-30-2005, 03:40 PM

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" <EdoZwart.20ufyy_1135930501.2578@excelforum-nospam.com> wrote in
> message news:EdoZwart.20ufyy_1135930501.2578@excelforum-nospam.com...
> >
> > 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
> >
>
>
>

Welcome to the Excel Forum

Forum Statistics