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" wrote in message
...
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" wrote in message
...
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(D 3=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?