Question

when dropdownlist is to be added to a field you use​

Answer 1

Explanation:

dropdown list

In this video, we'll build a dropdown list using dynamic arrays to filter data.

Here we have data in an Excel Table called "data".

In cell J2, I'll set up dropdown list we can use to filter data by color.

First, I'll type "Red" in J2, so we have something to filter on.

Next, I'll enter the FILTER function in cell I5. For array, we want the full table. For the include argument, we use an expression to compare values in the color column to cell J2.

When I enter the formula, we get a list of records where the color is "red".

If I replace "red" with "blue", we get a new set of data, so we can see the FILTER function is working properly.

Now, we don't want to type colors into cell J2. We want to select colors from a dropdown list and for this, we'll need data validation.