Hello everyone. I'm still working on the same file that yesterday I asked about on COUNTIFS and INDIRECT based on multiple criteria and from different worksheets. That one is now ok but I have another concern. Thank you for the help.
My concern now is that I need to have data validation in column L which depends on the conditions in columns E,F,G. The column L should have dependent drop down list based on the competencies chosen in columns E,F,G. The competencies are listed on three different worksheets. I tried Vlookup with indirect and Index-match-indirect but maybe I entered a wrong variable or something.
Any help will be greatly appreciated. Thank you
Here's a copy of the file I'm working on Competency Tracker_02Dec2021.xlsm
My concern now is that I need to have data validation in column L which depends on the conditions in columns E,F,G. The column L should have dependent drop down list based on the competencies chosen in columns E,F,G. The competencies are listed on three different worksheets. I tried Vlookup with indirect and Index-match-indirect but maybe I entered a wrong variable or something.
Any help will be greatly appreciated. Thank you
Here's a copy of the file I'm working on Competency Tracker_02Dec2021.xlsm