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.

Find more posts tagged with

Formulas

functionality

Accepted answers

Frank Falco

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.

All comments

Frank Falco

Unfortunately not. You cannot have a formula and also allow user entry. If the user sets a value then the formula is overwritten.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.