Vlookup returns drop down list

jeffreybrown · #1 11-17-2016, 06:15 AM

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

andrew_milonavic · #2 11-17-2016, 06:35 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Having a Drop-down list in Word referring to an Excel list	celias	Word VBA	3	07-11-2016 11:40 PM
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change	djrobst	Excel	4	10-28-2015 01:32 AM
Vlookup returns inconsistent results	Jhnsnkth527	Excel	0	04-16-2015 12:36 PM
Create list using VLOOKUP and IF?	Ineedcoffee	Excel	4	12-06-2011 01:49 AM