Data Validation Dropdown Return Multiple Values

JansiJansi

New Member
Joined
Jun 22, 2022
Messages
19
Office Version
  1. 365
Platform
  1. Windows
Hi!

Here's what I want to do: Fill out a project plan and have a custom learning path for each client depending on their needs.

There will be sections, such as "Warehouse Setup". Each section will have a dropdown with workflow options. Depending on the option, there will be either a single or multiple links to supplementary learning videos that populate.

For "Warehouse Setup", there would be the following options, for example:
- Internal Warehouse (links to 2 documentation videos/articles)
- External Warehouse (links to 1 documentation video/article)
- General Location Schema (links to 1)
- Complex Location Schema (links to 3)

If they planned on using multiple options (ie general AND complex locations), multiple would be selected, and then a link to the documentation for each option would be displayed, like:

Data Validation Selection (2 options)Return 1Return 2Return 3Return 4
General Location Schema, Complex Location Schemageneral doc 1complex doc 1complex doc 2complex doc 3

I have an idea on how to do this, but I get hung up on:
1. Multiple options being selected and if this is possible (it is in Google Sheets - see this: )
2. A single value returning multiple links to documentation (I know how to do it with a single)

Thank you!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,215,051
Messages
6,122,871
Members
449,097
Latest member
dbomb1414

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top