Hello,

I have created named tables, named ranges and set up data validaton.
Table 1 has two columns (example data to illustrate)
COLOR TextString
Blue Blue is the color of the sky
Blue Blue is the color of the ocean
Red Stop signs are red
Red Blood is red
Yellow They call her mellow yellow

Table 2 simply is a list of the COLORs (Blue, Red, Yellow)

Is there syntax or a method that will display the TextString of the dependent dropdown for selection based on the color selected?
If user selects "Red" from dropdown, then second dropdown displays as a list with two selections of "Stop signs are red" and "Blood is red".

I am using OFFSET with MATCH functions. Appears to work with a single text entity.

Thanks!

Would this require VBA?