Going to give it a go now. Thank you.

"Toppers" wrote:

TRY:

Create a table with the I4 selections and corresponding range names. Name
this table e.g. "Selections"

Col A Col B
Cholesystectomy=Chole
Nissen Fundoplication ==Nissen

Using data Validation for J4, select LIST and set SOURCE to:

=indirect(VLOOKUP(I4,SELECTIONS,2,0))

HTH

"Leisl" wrote:

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.