Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel Data Validation

Copper Contributor


I am working on an excel sheet where I want the input of a cell in a data entry sheet to be either a drop down option or a 6 digit number, depending on the input in the cell above. The above cell is item class and the next cell is item, if the item class is set to "Other" I would like it to allow a 6 digit item code to be entered. And if it is a standard item then the dropdown list will change accordingly.


I currently have the dynamic drop down list working but do not know how to get the cell to allow me to input a 6 digit number if the item class is set to other "Other".




1 Reply



You could help us help you if you gave a bit more information about 

(a) how you've managed to create the drop down list when it's NOT "Other"?

(b) when a person selects "Other" are any random 6 digits acceptable, or is that too a constrained list? 


Ideally, you would also post a copy of the spreadsheet you have created so far -- posting it on OneDrive or GoogleDrive with a link here that grants access to it.  (In the absence of that, you're asking us to do a lot of guessing on your format, the source of the list you already have, etc.)