Forum Discussion
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...
What I did to create drop down of Processes associated with Plan:
- Data tab, cell K1: Entered a formula to filter for Processes based on Plan selected in Detail tab, cell C5.
- Detail tab, cell F5: Created drop down with its source referencing the Spill Range (Data tab, cell K1).