Return multiple results based on a variable cell.

[Surferol]

Hi,
I want to use the value of a drop down box (already setup) to produce a list of identifiers from another sheet.
In the 2 screenshots, the yellow box of the timeline tab will be a drop down box, this will be the responsible units.
I want to select a responsible unit and all the ID names associated that unit is responsible for will automatically fill in in column B.

Thank you in advance,

 

[Surferol]

How about

=IF(A1="All",INDEX(CLSDIndex[ID],),FILTER(...

Awesome, thank you so much.

 

[Fluff]

My pleasure.