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...
Also, before you key the name into the name manager, be sure to select the cell in which you want the dropdown to appear (the B11 cell reference in the formula is relative to whatever cell is active when you key the formula - I'm assuming the active cell when it's entered is to the immediate right - C11). So if you want the data validation to apply to range C2:C20, then you would select C2:C20, and with C2 as the active cell in the selection, the named formula becomes (have to change B11 to B2).
=INDEX(Table1[Contact],MATCH(B2,Table1[Client],0)):INDEX(Table1[Contact],MATCH(B2,Table1[Client],1))
=INDEX(Table1[Contact],MATCH(B2,Table1[Client],0)):INDEX(Table1[Contact],MATCH(B2,Table1[Client],1))