Forum Discussion
Solved
Need help creating a dynamic list on excel 2016
Hi, I am currently using Excel 2016 and I need help to get a dynamic list based on an input. for instance, I have a dataset with 4 columns out of which I need to give an input (which is a val...
=IFERROR(INDEX($C$2:$C$11,SMALL(IF($B$2:$B$11=$F$5,ROW($A$2:$A$11)-1),ROW(E1))),"")Maybe with this formula. Enter the formula with ctrl+shift+enter as you don't work with Office365 or 2021.
A PivotTable with Col2 as a filter and Col3 as a row would be a simple solution if you're looking to create the DV List column from values found in Col3 as filtered by the selector Input which is populated with distinct values from Col2.
Below the value A is selected in the PivotTable filter, Input producing the PivotTable row, DV list. The list is then used to validate the data in cell I7, Validated Selection.
Not sure if this is exactly what you wanted to do. Hope it helps.