Vlookup returns drop down list

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup returns drop down list

FAQ

Thread Tools

Display Modes

11-17-2016, 06:15 AM

jeffreybrown jeffreybrown is offline

Windows Vista Vlookup returns drop down list

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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

Demo.xlsx (9.8 KB, 18 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:40 AM.