The INDEX & MATCH formulas and the Named Ranges and Data Validation in the attached workbook are working well and as I desired. I just want an expert’s opinion and to see if there are better alternatives/improvement chances. Sheet SCMEmpData cell B5 & D5 has the validation lists which are interdependent. Any advice from the experts here is highly appreciated.
Bookmarks