Have you looked at http://www.contextures.com/xlDataVal13.html#Depend

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Leisl" wrote in message
...
pls can somone help me. I have posted on here previously but the advice
given didn't work. I know what I want doing can be done but I just don't
know how to do it! I also think I will have to email my spreadsheet to
someone as my explanation is not very straight forward.

So, in the spreadsheet I have two tabs, the main page, where I am creating
my formulas and data where I have all my "lists" created as named ranges.

So in the main page tab in cell I4 I have created a drop down list which
gives names of operations. This list is created from the "operations"
named
range on the data sheet (cells A3:A20).

What I want to happen is, if for example I select Cholesystectomy from the
drop down list in I4 on the main page, I want cell J4 to offer me a drop
down
list based on the named range of chole which is on the data sheet (T3:T5).
If I selected Nissen Fundoplication in from the drop down list in I4 then
I
want cell J4 to offer me a drop down list based on the named range of
nissen
on the data sheet (U3:U6), then if I selected Hellers in I4 I want J4 to
give
me the drop down list of hellers and so on.

So in summary, I have about 15 things in the drop down list of
"operations"
in cell I4, then for each of these 15 things I have an additional
individual
drop down list of 3 or 4 items. I obviously need the drop down list in J4
to
be relevant to my first selection in I4.

Pls help, thank you in advance.