Forum Discussion

V-GEe7's avatar
V-GEe7
Brass Contributor
Jun 05, 2022
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...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Jun 05, 2022

    V-GEe7 

    =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.

Resources