Forum Discussion
Combine VLOOKUP and Data Validation drop list
I am trying to use VLOOKUP which works but I want to know if there are multiple results in the table_array can it combine with data validation. I can get them both working but not together. In da...
Assuming you can rely on the Table to be sorted by Client, you could set up a named formula, (Formulas\Names Manager
Name: ContactList
Scope: Workbook
RefersTo: =INDEX(Table1[Contact],MATCH(B11,Table1[Client],0)):INDEX(Table1[Contact],MATCH(B11,Table1[Client],1))
For your Data Validation, select List and Source: =ContactList
Data validation doesn't seem to like having structured table references in it's Source, so there's an added step of using a named formula.