Trying to Create a Conditional Drop down list

G

Guest

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 the
=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?
 
G

Guest

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
 
A

Anne Troy

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
 

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

IF statement based on True/False that activates a certain list box 1
Array Substitution Based on Drop Down List 1
Advice on a couple of things if possible. 3
Reduce Numbers Down To A Specific Value 1
conditional drop down list problem 1
Conditional Formatting a drop down list 2
hlookup within a conditional function 1
create a summary page that will take a list and remove empty rows 3

Top