Hello My Masters & Colleagues, I have 3 columns of data in sheet2 (A) for Branches (B) for Departments and (C) for Names A2:c5000 like the table below the 3 lists are related and has some duplicates and blanks. And I have 3 Columns lets say J,K,L in sheet1 I want to J2:J each cell is validation...