dynamic dependent drop down list based on input with reference to a two column table

		Microsoft Office Forums > Microsoft Excel > Excel
dynamic dependent drop down list based on input with reference to a two column table

FAQ

Thread Tools

Display Modes

05-23-2018, 08:15 AM

Roger Govier Roger Govier is offline

Windows 10 dynamic dependent drop down list based on input with reference to a two column table

Office 2016

Novice

Join Date: Oct 2017

Location: Abergavenny, Wales, UK

Posts: 13

Hi

Why make life difficult for yourself by continuing with a two column unsorted table?
You could easily extract a list of countries belonging to each Continent to create 5 individual tables.
Then you can achieve what you want very easily as described in a Tutorial I posted here
http://www.contextures.com/exceldata...sindirect.html

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Increase number in cell, based on value in adjacent cell	scottyb	Excel	3	02-02-2017 03:51 AM
Help with Vlookup in a Dependent drop down list	angelmr	Excel	0	11-29-2016 09:25 AM
Get all rows based on input values from a list	soolsen	Excel	1	03-27-2016 08:11 PM
How to "hard link" two adjacent cells to a data validation drop down list?	Geza59	Excel	10	10-19-2012 11:56 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell	Frogggg	Excel	1	10-25-2011 08:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:37 PM.