Conversion

Hello,

I have a drop down list in one column, and based on what is selected in that column. I would like my data to convert based on information in another.

I have tried Vlook up and If statement but have been unsuccessful.

For Example, if someone selects 5347550 on the form, I want the column on the sheet to convert to

If understand, I will need a data sheet but other than that have not been successful

Find more posts tagged with

Accepted answers

All comments

MariaCurtis

Hi! Can you share a few more details?

How many options are in the drop-down column people are selecting from? That might help determine whether an if statement or vlookup makes more sense.
Can you share what formulas you have tried, and what's happening when you use them?
Are you using a "helper" sheet? (for the vlookup attempts)

RG3

Hi,

Thank you for your attention to this matter

I have about 8 groups like this, on my form, allow them to use the short version (right) however, do complete my upload, I need it to convert to the complete version (left).

I have tried Vlook up and I am getting #nomatch and when i completed an attempt at in if statement it told me #unparseable

Can you provide my more guidance on the helper sheet

Paul Newcome

You would need to set up a second sheet with a list like the one you have in the screenshot where the selections are in one column and the desired lookups are in another column. Then you would use something like this:

=INDEX({Reference Sheet Output Column}, MATCH([Dropdown Column Name]@row, {Reference Sheet Selection Column}, 0))

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.