I'm not so sure it's going to work with a vlookup controlling a data validation, but check out this example. Using D2, if the user enter a 1 then the array Fruit is returned, but if a 2, then Vegetable array is returned. Look at K1.
This is all done with an if statement inside the data validation source.
Just one thought
|