Quote:
Originally Posted by jeffreybrown
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
|
Thanks Jeffrey,
I'll have to play around with the concept. I was trying to get around having to use "if" statements. Were using conversion software that takes excel files and turns them into html with a server side node.js and it has limitations as to how many "if" statements I can use per cell.
Thanks
Andrew