Automatically select drop down list option based on value of other cell
Hi all
I have a column with cells that are populated from a drop down list. I would like one of the list options to be populated auotmatically based on the value of another cell but I am not sure if this is possible.
I would usually use an IF formula for this but can’t with a drop down list as the cells are restricted to the list options so no formla can be added to them. Is there another way to do it?
Thank you
Hi all I have a column with cells that are populated from a drop down list. I would like one of the list options to be populated auotmatically based on the value of another cell but I am not sure if this is possible.I would usually use an IF formula for this but can’t with a drop down list as the cells are restricted to the list options so no formla can be added to them. Is there another way to do it?Thank you Read More
