That's quite a work around! (I'm not complaining) ...it'll be tomorrow though before I have time to digest and process it, but I sincerely appreciate the assistance!
Ok... this is close... in column [Region] on the "DataTable" - I need the data validation to return a list of the employee names of only those matching the [Level] "Asst Sup" and "Manager" for the corresponding [Region] in column B, per the Employee Table.
I don't have a sample, but can make one if needed... but I think I can describe what I need pretty easily.
On sheet "Data Table" I have a table for data entry and am using data validation and formulas. On sheet "Data Validation" I have another table, "EmpTable", with 4 columns: Region (col. A)...