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
Answers
-
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)
-
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
-
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))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!