Forum Discussion
INDEX, MATCH, THEN DATA VALIDATION LIST Created in Table?
My objective is this: I am working with a table, and pivot tables, to track exceptions on loan document preparation. So, I have a list of general categories of exceptions, and deeper into those cate...
AngelaSmith0916 Hello there. If I'm understanding you correctly, you want to be able to choose an item in the 'Exc Type' column (on 'MyTable' sheet, in 'Table1'), and then have a drop down in 'Exception Notes' dependent upon your selection. If this is correct, yes, it's possible. However, with your data, I'm not sure I follow how you're determining the dependent data. For example, if you choose "Vin", where is the dependent data specifically? It looks like you currently have two disparate tables of data on 'Validation' sheet.
Here are two examples of how to perform dependent validation:
https://exceljet.net/dependent-dropdown-lists
https://contextures.com/xlDataVal02.html