Drop Down List with Conditions

[wardp9541]

I am trying to create a drop down list on the calculation page (where it says Equipment tag). I wanted this drop down list to include all equipment with "Floor" mounting.

I have tried to use index(array, match (), 1,0), but that only includes one value. I would like for it to include all equipment tags that have the floor-mounting.

How can I do this?

 

[jorismoerings]

Hi,

You didn't give us much to work with. Have a look at the forum guidelines and tips when posting a question next time.
With a better formulated question, you're helping us to help you.

As you're using O365, try this:

=UNIQUE(FILTER(H2:H8, P2:P8="floor"))