Only allow certain data in a cell depending on value of another cell

[Loociiee]

Hi All,

I am trying to find a way to disallow the entry of certain data depending on the value of another cell. I have a list of 13 items to choose from AD001, AD002 etc in one column and 4 workflows: 30, 75, v4 and v5 to choose from to populate the second column. We only use 12 at a time and for workflows v4 and v5 we aren't allowed to use AD013 and for 30 and 75 we're not allowed to use AD003. Is there a way to prevent entry of AD013 if the workflow is either v4 or v5 and same for AD003 if the workflow is 30 or 75.

Thanks you in advance,

Lucy

[FDibbins]

Hi, welcome to teh forum

You would probably need to use Data Validation, but to be more specific, I would need to see a sample of what you are working with, and what you want
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Tony Valko]

You can do this using data validation.

Let's assume A1 = workflow and B1 = code

Select cell B1
Goto the Data tab>Data Validation
Allow: Custom
Formula: =NOT(AND(B1="AD013",OR(A1="v4",A1="v5")))
OK out

You can use the same logic for other combinations as needed.