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
Bookmarks