List validation error

[Christopher]

Hi

on my excel file I have 2 sheets

First Sheet (Sheet 1): User Enter Data , on thsi sheet I
have a cell where the Validation is a liste, so on this
Cell I have a comboBox where the user can choose data
from a liste.

This list is declared on the second sheet of my file.

My problem now that I have 2 differents lists, and
depending on what the user choose in a cell I have to
choose the right liste

Ex:

I have a cell which contains liste of Female or male

If user choose for A10: Female I have to display on D10
the list FemaleFirstName

If user choose for A10: Male I have to display on D10 the
list MaleFistName

What I did is the following:

in Options --> Validation

I choose List

Source : =If(A10=Female; FemaleFirstName;MaleFirstName)

The error message that I have to put (') after the = I
tried but it's not working, do you have any idea why
please

Any help

 

[JulieD]

Hi Christopher

you might like to check out Debra Dalgleish's website for ideas on how to
achieve this - my internet isn't working at the moment so i can't give you
the exact web address but if you go to www.contextures.com/tiptech.html (the
index page for her site) and look under data validation i'm sure you'll find
it.

Cheers
JulieD

 

[Max]

Just a finer add-on to Julie's suggestion ..
(because its usually very easy to be distracted
by the many useful stuff one finds in Debra's site <bg>)

so zoom into: http://www.contextures.com/xlDataVal02.html
where "Data Validation - Create Dependent Lists" resides

 

[Christopher]

Hi Julie

Thank you very much

Chris

-----Original Message-----
Hi Christopher

you might like to check out Debra Dalgleish's website for ideas on how to
achieve this - my internet isn't working at the moment so i can't give you
the exact web address but if you go to

www.contextures.com/tiptech.html (the