We’ll also look at how to use the values in a table for data validation.
This table contains a list of projects showing a sales pipeline.
The last column is meant to show the current state of a given opportunity.
To the right, in column G, is a list of possible stages.
And if I venture to enter any value not on the list, Excel will display a warning.
If I add a new row to the table, it also picks up the data validation.
So this works pretty well.
This is expected, because there is nothing dynamic about the current setup.
Let’s try it out.
First, I’ll convert the list of stages to a table.
At this point, nothing changes.
The data validation continues to work normally.
But notice if I add a new stage, it automatically appears in the dropdown.
Unfortunately, you’ve got the option to’t usestructured referencesdirectly in the data validation input window.
If you venture to do this, Excel will complain.
We’ll look at how to do this in a separate video.
