VLOOKUP plus a Dropdown selection???
I don't think this is possible, but thought I'd ask here. I have a situation where I would like to look up a value in another worksheet if the the value in a column adjacent to the lookup contains "DMP". I know how to write that formula, but if the value does not contain DMP, then I don't want the lookup at all, but want people to be able to choose a couple of remaining values from a dropdown.
Can this even be done? I think I'm going to have to figure out another way to achieve a similar result.
Thanks.
Best Answer

Unfortunately not. You cannot have a formula and also allow user entry. If the user sets a value then the formula is overwritten.
You could do this by using multiple columns, one column for user entry and one for the formula and one that combines the result of the two, but I do not think that would be a intuitive user experience.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Answers

Unfortunately not. You cannot have a formula and also allow user entry. If the user sets a value then the formula is overwritten.
You could do this by using multiple columns, one column for user entry and one for the formula and one that combines the result of the two, but I do not think that would be a intuitive user experience.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 406 Global Discussions
 218 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!