Forum Discussion
Excel formula assistance please
Hi All, I am relatively new to trying to create formulas. And use excel help, but cant find an answer to this question.... alsoI have no idea how to post a copy of what I am doing in here like m...
Hi, Mick! Please try the following:
- go to the cell where you have the drop-down list
- Data > Data Validation
- on the dialogue box, activate the tab "Error Alert"
- under Style, choose "Information"
- Under Title, you can write: "Name not listed"
- Under Error message, you can write: "The name you entered is not listed yet. Would you still like to use it?"
Now test: enter a name that does not exist on the dropdown list on the cell with that data validation rule. You get a warning, but you are allowed to add a name that does not exist on the list.
You can also test the Style "Warning."
I hope this helps. Good luck!
Celia