J
jujurainbow
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
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