Forum Discussion
JTB76
Feb 28, 2025Copper Contributor
Vlookup and Drop Downs
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 list Plan ID is using a Vlookup to the same list as above and w...
JTB76
Mar 04, 2025Copper Contributor
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.
HansVogelaar
Mar 04, 2025MVP
Does this do what you want?