Vlookup and Drop Downs

Question

Hi All,I have the below table that I need some help with.Business Area and Plan Name are just using a data validation look up to a listPlan ID is using a Vlookup to the same list as above and will bring back the corresponding Plan ID according to the Plan Name.&nbsp; The same for Primary Resilience Rep.&nbsp;&nbsp;Where I need help is for the Process Name column.&nbsp; For each plan there could be multiple Processes associated.&nbsp; What I would like to do is somehow have it so that when the Plan Name is selected by the user, the Process Name column will have a drop down list of associated Processes that the user can choose from.&nbsp; The drop down list can be the same on each row:&nbsp; The user will just need to see which processes they have already selected.&nbsp;Is this possible at all?&nbsp;ThanksJames.&nbsp;&nbsp;

hansvogelaar · Answer

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

jtb76 · Answer

Hi - Thanks so much for your assistance. I have attached a simplified version will only the data columns that I am interested in. So what I am trying to achieve, is when I select the plan name on the first tab, the business area, plan ID, Primary Res Rep, Process Tier and Process Names all auto populate. However, with the Process Names there are multiple. Sp I either need the Process Name row to have a drop down with the assosiated Processes listed so that the user can select the ones they want to include, or, if easier, just list all the processes (1 on each row) in column F (only want those with a Tier rating of 1, 2 or 3 included).

Thanks for helping.

Business Continuity Testing Template 2025.xlsx21 KB