julieelyse
New Member
- Joined
- Feb 3, 2023
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
The best way to describe what I need is to just give an example...
I have a group of people using the same spreadsheet Column A currently has a drop down with the following values 'not selected' 'cat', 'dog', 'bird'. I need to change this so that, if column B has a value of 'color' I want the drop down in column A to have the following values; 'not selected', 'cat'. If column B displays any other value, I want column A drop down to have the following values' 'not selected'; 'dog', 'bird'.
I have a group of people using the same spreadsheet Column A currently has a drop down with the following values 'not selected' 'cat', 'dog', 'bird'. I need to change this so that, if column B has a value of 'color' I want the drop down in column A to have the following values; 'not selected', 'cat'. If column B displays any other value, I want column A drop down to have the following values' 'not selected'; 'dog', 'bird'.