Excel conditional drop-down list using table ref.

I got this table of vehicles named VehicleList to maintain overview of active vehicles. All entries are formatted as text.

Now, I need a drop-down list with IDs of only active vehicles from VehicleList, e.g. when ACTIVE = 1

For now I know that placing the formula =INDIRECT("VehicleList[ID]") into Source gives me all the IDs from VehicleList.

But how do I include the conditional part?


The wanted result to following example is a drop-down list of IDs: 1, 3, 5