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.
=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.
Thank you so much, tbh, That was helpful.
however, I am not able to use that formula with data validation.
is there anyway I can get this to work with datavalidation?
Data validation list works with reference. First you need to create the list at any place and when use it in data validation.
