Hi Juju,

See Debra Dalgleish's page on dependent lists at:

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


---
Regards,
Norman


"jujurainbow"
wrote in message
...

In column A all cells are validation cell (when you click on it you have
a list that appears and you have to select in). I would like that people
could chose data in a list in column B. But the value in the list (in
the cell belonging to column B) would depend on the value in the cell
that are situated in column A. For instance if i chose value X in cell
A1 a autolist that is linked to this value X will appear in B1. But if
i had chosen another value in cell A1 i would have had another autolist
in B1. I thought i could write like this : =if(A1=X,autolist=a,....)
in B1 but it doesn't work. Could you help ! Thanks


--
jujurainbow
------------------------------------------------------------------------
jujurainbow's Profile:
http://www.excelforum.com/member.php...o&userid=31612
View this thread: http://www.excelforum.com/showthread...hreadid=513042