Forum Discussion
Vlookup and Drop Downs
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.
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.
Does this do what you want?
I see the reply now. I'll take a look.