View Single Post
 
Old 11-17-2016, 06:15 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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
Attached Files
File Type: xlsx Demo.xlsx (9.8 KB, 18 views)
Reply With Quote