Hi All, the CONTEXTURES link is not helping. Is there any other alternative?
Is there somewhere I can go where the formula is written for me as none of
these responses are working.

"Debra Dalgleish" wrote:

You could set up a table that lists the ranges to use for each
selection, as described he

http://www.contextures.com/xlDataVal02.html#Illegal


Leisl wrote:
Hi, thanks but none of this is helping. I have looked at the link before and
it doesn't address the problem.

the lists that I want to populate in my second cell ie the cell that is
dependent on the contents of the first cell are not called the same this is
because I have other sets of data later in the spreadsheet that need to be
dependent on that first cell.

"Toppers" wrote:


See

http://www.contextures.com/xlDataVal02.html

Basically, if the names in drop down list in I4 match exactly the named
ranges i.e. 'Cholesystectomy' is the named range NOT 'Chole', then using Data
Validation in J4, select List and put "=INDIRECT(I4)" (no quotes) in Source.

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.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html