Trying to Create a Conditional Drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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
 
Back
Top