Trying to Create a Conditional Drop down list

No code necessary, Noel. Likely you can use a vlookup. See the link below.
While you may not want an order form or invoice, you're wanting virtually
the same thing.
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Noel" <[email protected]> wrote in message
news:[email protected]...
> I am trying to create a form that contains conditional drop down lists for
> the user to selct from. i want the user to be able when theypick from a
list
> i created in cell D3 and when they choose that i want a list to be created
in
> cell E3 which contains data from a second worksheet. I was able to make it
> work using nested if statements for validation but the problem is that it
> wont let me go past 7 and i need to do about 50 of them. To make things
> easier i defined names to reference all the data on the second worksheet.
> This is what i used and it would work if i could do about 50 of them
>
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> matching the cell D3 to data i used to create the list really just
matching
> itself to itself.
> I know there has to be some simple VB code to make it work or some simple
> solution, and i do have some experience using vb code but not in this kind
of
> enviroment.
> Does Anyone have any ideas?

My problem with vlookup is from my understanding is that the data has to be
in the same colum and the value that i am trying to return from the match is
a range on another worksheet and from my understanding of vlookup it cant
return a defined name

"Anne Troy" wrote:

> No code necessary, Noel. Likely you can use a vlookup. See the link below.
> While you may not want an order form or invoice, you're wanting virtually
> the same thing.
> http://www.officearticles.com/tutori...soft_excel.htm
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "Noel" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to create a form that contains conditional drop down lists for
> > the user to selct from. i want the user to be able when theypick from a
> list
> > i created in cell D3 and when they choose that i want a list to be created
> in
> > cell E3 which contains data from a second worksheet. I was able to make it
> > work using nested if statements for validation but the problem is that it
> > wont let me go past 7 and i need to do about 50 of them. To make things
> > easier i defined names to reference all the data on the second worksheet.
> > This is what i used and it would work if i could do about 50 of them
> >
> =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
> in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > matching the cell D3 to data i used to create the list really just
> matching
> > itself to itself.
> > I know there has to be some simple VB code to make it work or some simple
> > solution, and i do have some experience using vb code but not in this kind
> of
> > enviroment.
> > Does Anyone have any ideas?
>
>
>

There are instructions here for creating dependent data validation lists:

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

Noel wrote:
> I am trying to create a form that contains conditional drop down lists for
> the user to selct from. i want the user to be able when theypick from a list
> i created in cell D3 and when they choose that i want a list to be created in
> cell E3 which contains data from a second worksheet. I was able to make it
> work using nested if statements for validation but the problem is that it
> wont let me go past 7 and i need to do about 50 of them. To make things
> easier i defined names to reference all the data on the second worksheet.
> This is what i used and it would work if i could do about 50 of them
> =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> matching the cell D3 to data i used to create the list really just matching
> itself to itself.
> I know there has to be some simple VB code to make it work or some simple
> solution, and i do have some experience using vb code but not in this kind of
> enviroment.
> Does Anyone have any ideas?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

If you read the instructions at the link, Noel, it tells you how to use a
named range for the lookup range. When you use a named range, it does NOT
have to be on the same worksheet.

*******************
~Anne Troy

www.OfficeArticles.com


"Noel" <[email protected]> wrote in message
news:[email protected]...
> My problem with vlookup is from my understanding is that the data has to
be
> in the same colum and the value that i am trying to return from the match
is
> a range on another worksheet and from my understanding of vlookup it cant
> return a defined name
>
> "Anne Troy" wrote:
>
> > No code necessary, Noel. Likely you can use a vlookup. See the link
below.
> > While you may not want an order form or invoice, you're wanting
virtually
> > the same thing.
> >
http://www.officearticles.com/tutori...soft_excel.htm
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> >
> >
> > "Noel" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am trying to create a form that contains conditional drop down lists
for
> > > the user to selct from. i want the user to be able when theypick from
a
> > list
> > > i created in cell D3 and when they choose that i want a list to be
created
> > in
> > > cell E3 which contains data from a second worksheet. I was able to
make it
> > > work using nested if statements for validation but the problem is that
it
> > > wont let me go past 7 and i need to do about 50 of them. To make
things
> > > easier i defined names to reference all the data on the second
worksheet.
> > > This is what i used and it would work if i could do about 50 of them
> > >
> >
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
> > in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > > matching the cell D3 to data i used to create the list really just
> > matching
> > > itself to itself.
> > > I know there has to be some simple VB code to make it work or some
simple
> > > solution, and i do have some experience using vb code but not in this
kind
> > of
> > > enviroment.
> > > Does Anyone have any ideas?
> >
> >
> >

Thank you, that seems to be working great

"Debra Dalgleish" wrote:

> There are instructions here for creating dependent data validation lists:
>
> http://www.contextures.com/xlDataVal02.html
>
> Noel wrote:
> > I am trying to create a form that contains conditional drop down lists for
> > the user to selct from. i want the user to be able when theypick from a list
> > i created in cell D3 and when they choose that i want a list to be created in
> > cell E3 which contains data from a second worksheet. I was able to make it
> > work using nested if statements for validation but the problem is that it
> > wont let me go past 7 and i need to do about 50 of them. To make things
> > easier i defined names to reference all the data on the second worksheet.
> > This is what i used and it would work if i could do about 50 of them
> > =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > matching the cell D3 to data i used to create the list really just matching
> > itself to itself.
> > I know there has to be some simple VB code to make it work or some simple
> > solution, and i do have some experience using vb code but not in this kind of
> > enviroment.
> > Does Anyone have any ideas?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome! Thanks for letting me know that it helped.

Noel wrote:
> Thank you, that seems to be working great
>
> "Debra Dalgleish" wrote:
>
>
>>There are instructions here for creating dependent data validation lists:
>>
>> http://www.contextures.com/xlDataVal02.html
>>
>>Noel wrote:
>>
>>>I am trying to create a form that contains conditional drop down lists for
>>>the user to selct from. i want the user to be able when theypick from a list
>>>i created in cell D3 and when they choose that i want a list to be created in
>>>cell E3 which contains data from a second worksheet. I was able to make it
>>>work using nested if statements for validation but the problem is that it
>>>wont let me go past 7 and i need to do about 50 of them. To make things
>>>easier i defined names to reference all the data on the second worksheet.
>>>This is what i used and it would work if i could do about 50 of them
>>>=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
>>>matching the cell D3 to data i used to create the list really just matching
>>>itself to itself.
>>>I know there has to be some simple VB code to make it work or some simple
>>>solution, and i do have some experience using vb code but not in this kind of
>>>enviroment.
>>>Does Anyone have any ideas?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome! Thanks for letting me know that it helped.

Noel wrote:
> Thank you, that seems to be working great
>
> "Debra Dalgleish" wrote:
>
>
>>There are instructions here for creating dependent data validation lists:
>>
>> http://www.contextures.com/xlDataVal02.html
>>
>>Noel wrote:
>>
>>>I am trying to create a form that contains conditional drop down lists for
>>>the user to selct from. i want the user to be able when theypick from a list
>>>i created in cell D3 and when they choose that i want a list to be created in
>>>cell E3 which contains data from a second worksheet. I was able to make it
>>>work using nested if statements for validation but the problem is that it
>>>wont let me go past 7 and i need to do about 50 of them. To make things
>>>easier i defined names to reference all the data on the second worksheet.
>>>This is what i used and it would work if i could do about 50 of them
>>>=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
>>>matching the cell D3 to data i used to create the list really just matching
>>>itself to itself.
>>>I know there has to be some simple VB code to make it work or some simple
>>>solution, and i do have some experience using vb code but not in this kind of
>>>enviroment.
>>>Does Anyone have any ideas?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you, that seems to be working great

"Debra Dalgleish" wrote:

> There are instructions here for creating dependent data validation lists:
>
> http://www.contextures.com/xlDataVal02.html
>
> Noel wrote:
> > I am trying to create a form that contains conditional drop down lists for
> > the user to selct from. i want the user to be able when theypick from a list
> > i created in cell D3 and when they choose that i want a list to be created in
> > cell E3 which contains data from a second worksheet. I was able to make it
> > work using nested if statements for validation but the problem is that it
> > wont let me go past 7 and i need to do about 50 of them. To make things
> > easier i defined names to reference all the data on the second worksheet.
> > This is what i used and it would work if i could do about 50 of them
> > =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > matching the cell D3 to data i used to create the list really just matching
> > itself to itself.
> > I know there has to be some simple VB code to make it work or some simple
> > solution, and i do have some experience using vb code but not in this kind of
> > enviroment.
> > Does Anyone have any ideas?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

If you read the instructions at the link, Noel, it tells you how to use a
named range for the lookup range. When you use a named range, it does NOT
have to be on the same worksheet.

*******************
~Anne Troy

www.OfficeArticles.com


"Noel" <[email protected]> wrote in message
news:[email protected]...
> My problem with vlookup is from my understanding is that the data has to
be
> in the same colum and the value that i am trying to return from the match
is
> a range on another worksheet and from my understanding of vlookup it cant
> return a defined name
>
> "Anne Troy" wrote:
>
> > No code necessary, Noel. Likely you can use a vlookup. See the link
below.
> > While you may not want an order form or invoice, you're wanting
virtually
> > the same thing.
> >
http://www.officearticles.com/tutori...soft_excel.htm
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> >
> >
> > "Noel" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am trying to create a form that contains conditional drop down lists
for
> > > the user to selct from. i want the user to be able when theypick from
a
> > list
> > > i created in cell D3 and when they choose that i want a list to be
created
> > in
> > > cell E3 which contains data from a second worksheet. I was able to
make it
> > > work using nested if statements for validation but the problem is that
it
> > > wont let me go past 7 and i need to do about 50 of them. To make
things
> > > easier i defined names to reference all the data on the second
worksheet.
> > > This is what i used and it would work if i could do about 50 of them
> > >
> >
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
> > in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > > matching the cell D3 to data i used to create the list really just
> > matching
> > > itself to itself.
> > > I know there has to be some simple VB code to make it work or some
simple
> > > solution, and i do have some experience using vb code but not in this
kind
> > of
> > > enviroment.
> > > Does Anyone have any ideas?
> >
> >
> >

There are instructions here for creating dependent data validation lists:

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

Noel wrote:
> I am trying to create a form that contains conditional drop down lists for
> the user to selct from. i want the user to be able when theypick from a list
> i created in cell D3 and when they choose that i want a list to be created in
> cell E3 which contains data from a second worksheet. I was able to make it
> work using nested if statements for validation but the problem is that it
> wont let me go past 7 and i need to do about 50 of them. To make things
> easier i defined names to reference all the data on the second worksheet.
> This is what i used and it would work if i could do about 50 of them
> =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> matching the cell D3 to data i used to create the list really just matching
> itself to itself.
> I know there has to be some simple VB code to make it work or some simple
> solution, and i do have some experience using vb code but not in this kind of
> enviroment.
> Does Anyone have any ideas?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

My problem with vlookup is from my understanding is that the data has to be
in the same colum and the value that i am trying to return from the match is
a range on another worksheet and from my understanding of vlookup it cant
return a defined name

"Anne Troy" wrote:

> No code necessary, Noel. Likely you can use a vlookup. See the link below.
> While you may not want an order form or invoice, you're wanting virtually
> the same thing.
> http://www.officearticles.com/tutori...soft_excel.htm
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "Noel" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to create a form that contains conditional drop down lists for
> > the user to selct from. i want the user to be able when theypick from a
> list
> > i created in cell D3 and when they choose that i want a list to be created
> in
> > cell E3 which contains data from a second worksheet. I was able to make it
> > work using nested if statements for validation but the problem is that it
> > wont let me go past 7 and i need to do about 50 of them. To make things
> > easier i defined names to reference all the data on the second worksheet.
> > This is what i used and it would work if i could do about 50 of them
> >
> =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
> in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > matching the cell D3 to data i used to create the list really just
> matching
> > itself to itself.
> > I know there has to be some simple VB code to make it work or some simple
> > solution, and i do have some experience using vb code but not in this kind
> of
> > enviroment.
> > Does Anyone have any ideas?
>
>
>

No code necessary, Noel. Likely you can use a vlookup. See the link below.
While you may not want an order form or invoice, you're wanting virtually
the same thing.
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Noel" <[email protected]> wrote in message
news:[email protected]...
> I am trying to create a form that contains conditional drop down lists for
> the user to selct from. i want the user to be able when theypick from a
list
> i created in cell D3 and when they choose that i want a list to be created
in
> cell E3 which contains data from a second worksheet. I was able to make it
> work using nested if statements for validation but the problem is that it
> wont let me go past 7 and i need to do about 50 of them. To make things
> easier i defined names to reference all the data on the second worksheet.
> This is what i used and it would work if i could do about 50 of them
>
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> matching the cell D3 to data i used to create the list really just
matching
> itself to itself.
> I know there has to be some simple VB code to make it work or some simple
> solution, and i do have some experience using vb code but not in this kind
of
> enviroment.
> Does Anyone have any ideas?

Thank you, that seems to be working great

"Debra Dalgleish" wrote:

> There are instructions here for creating dependent data validation lists:
>
> http://www.contextures.com/xlDataVal02.html
>
> Noel wrote:
> > I am trying to create a form that contains conditional drop down lists for
> > the user to selct from. i want the user to be able when theypick from a list
> > i created in cell D3 and when they choose that i want a list to be created in
> > cell E3 which contains data from a second worksheet. I was able to make it
> > work using nested if statements for validation but the problem is that it
> > wont let me go past 7 and i need to do about 50 of them. To make things
> > easier i defined names to reference all the data on the second worksheet.
> > This is what i used and it would work if i could do about 50 of them
> > =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > matching the cell D3 to data i used to create the list really just matching
> > itself to itself.
> > I know there has to be some simple VB code to make it work or some simple
> > solution, and i do have some experience using vb code but not in this kind of
> > enviroment.
> > Does Anyone have any ideas?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

You're welcome! Thanks for letting me know that it helped.

Noel wrote:
> Thank you, that seems to be working great
>
> "Debra Dalgleish" wrote:
>
>
>>There are instructions here for creating dependent data validation lists:
>>
>> http://www.contextures.com/xlDataVal02.html
>>
>>Noel wrote:
>>
>>>I am trying to create a form that contains conditional drop down lists for
>>>the user to selct from. i want the user to be able when theypick from a list
>>>i created in cell D3 and when they choose that i want a list to be created in
>>>cell E3 which contains data from a second worksheet. I was able to make it
>>>work using nested if statements for validation but the problem is that it
>>>wont let me go past 7 and i need to do about 50 of them. To make things
>>>easier i defined names to reference all the data on the second worksheet.
>>>This is what i used and it would work if i could do about 50 of them
>>>=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
>>>matching the cell D3 to data i used to create the list really just matching
>>>itself to itself.
>>>I know there has to be some simple VB code to make it work or some simple
>>>solution, and i do have some experience using vb code but not in this kind of
>>>enviroment.
>>>Does Anyone have any ideas?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I am trying to create a form that contains conditional drop down lists for
the user to selct from. i want the user to be able when theypick from a list
i created in cell D3 and when they choose that i want a list to be created in
cell E3 which contains data from a second worksheet. I was able to make it
work using nested if statements for validation but the problem is that it
wont let me go past 7 and i need to do about 50 of them. To make things
easier i defined names to reference all the data on the second worksheet.
This is what i used and it would work if i could do about 50 of them
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
matching the cell D3 to data i used to create the list really just matching
itself to itself.
I know there has to be some simple VB code to make it work or some simple
solution, and i do have some experience using vb code but not in this kind of
enviroment.
Does Anyone have any ideas?

If you read the instructions at the link, Noel, it tells you how to use a
named range for the lookup range. When you use a named range, it does NOT
have to be on the same worksheet.

*******************
~Anne Troy

www.OfficeArticles.com


"Noel" <[email protected]> wrote in message
news:[email protected]...
> My problem with vlookup is from my understanding is that the data has to
be
> in the same colum and the value that i am trying to return from the match
is
> a range on another worksheet and from my understanding of vlookup it cant
> return a defined name
>
> "Anne Troy" wrote:
>
> > No code necessary, Noel. Likely you can use a vlookup. See the link
below.
> > While you may not want an order form or invoice, you're wanting
virtually
> > the same thing.
> >
http://www.officearticles.com/tutori...soft_excel.htm
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> >
> >
> > "Noel" <[email protected]> wrote in message
> > news:[email protected]...
> > > I am trying to create a form that contains conditional drop down lists
for
> > > the user to selct from. i want the user to be able when theypick from
a
> > list
> > > i created in cell D3 and when they choose that i want a list to be
created
> > in
> > > cell E3 which contains data from a second worksheet. I was able to
make it
> > > work using nested if statements for validation but the problem is that
it
> > > wont let me go past 7 and i need to do about 50 of them. To make
things
> > > easier i defined names to reference all the data on the second
worksheet.
> > > This is what i used and it would work if i could do about 50 of them
> > >
> >
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
> > in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > > matching the cell D3 to data i used to create the list really just
> > matching
> > > itself to itself.
> > > I know there has to be some simple VB code to make it work or some
simple
> > > solution, and i do have some experience using vb code but not in this
kind
> > of
> > > enviroment.
> > > Does Anyone have any ideas?
> >
> >
> >

There are instructions here for creating dependent data validation lists:

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

Noel wrote:
> I am trying to create a form that contains conditional drop down lists for
> the user to selct from. i want the user to be able when theypick from a list
> i created in cell D3 and when they choose that i want a list to be created in
> cell E3 which contains data from a second worksheet. I was able to make it
> work using nested if statements for validation but the problem is that it
> wont let me go past 7 and i need to do about 50 of them. To make things
> easier i defined names to reference all the data on the second worksheet.
> This is what i used and it would work if i could do about 50 of them
> =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> matching the cell D3 to data i used to create the list really just matching
> itself to itself.
> I know there has to be some simple VB code to make it work or some simple
> solution, and i do have some experience using vb code but not in this kind of
> enviroment.
> Does Anyone have any ideas?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

My problem with vlookup is from my understanding is that the data has to be
in the same colum and the value that i am trying to return from the match is
a range on another worksheet and from my understanding of vlookup it cant
return a defined name

"Anne Troy" wrote:

> No code necessary, Noel. Likely you can use a vlookup. See the link below.
> While you may not want an order form or invoice, you're wanting virtually
> the same thing.
> http://www.officearticles.com/tutori...soft_excel.htm
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "Noel" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to create a form that contains conditional drop down lists for
> > the user to selct from. i want the user to be able when theypick from a
> list
> > i created in cell D3 and when they choose that i want a list to be created
> in
> > cell E3 which contains data from a second worksheet. I was able to make it
> > work using nested if statements for validation but the problem is that it
> > wont let me go past 7 and i need to do about 50 of them. To make things
> > easier i defined names to reference all the data on the second worksheet.
> > This is what i used and it would work if i could do about 50 of them
> >
> =IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
> in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> > matching the cell D3 to data i used to create the list really just
> matching
> > itself to itself.
> > I know there has to be some simple VB code to make it work or some simple
> > solution, and i do have some experience using vb code but not in this kind
> of
> > enviroment.
> > Does Anyone have any ideas?
>
>
>

No code necessary, Noel. Likely you can use a vlookup. See the link below.
While you may not want an order form or invoice, you're wanting virtually
the same thing.
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Noel" <[email protected]> wrote in message
news:[email protected]...
> I am trying to create a form that contains conditional drop down lists for
> the user to selct from. i want the user to be able when theypick from a
list
> i created in cell D3 and when they choose that i want a list to be created
in
> cell E3 which contains data from a second worksheet. I was able to make it
> work using nested if statements for validation but the problem is that it
> wont let me go past 7 and i need to do about 50 of them. To make things
> easier i defined names to reference all the data on the second worksheet.
> This is what i used and it would work if i could do about 50 of them
>
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,IF(D3=K16,Camino,IF(D3=K17,Adm
in,IF(D3=K18,Arroyo,IF(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
> matching the cell D3 to data i used to create the list really just
matching
> itself to itself.
> I know there has to be some simple VB code to make it work or some simple
> solution, and i do have some experience using vb code but not in this kind
of
> enviroment.
> Does Anyone have any ideas?