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
Check out the Formula Handbook template!