Excel Data Validation - List

Md1

Board Regular
Joined
May 23, 2003
Messages
126
Hi all

A good while ago I found a way to use data validation to achieve the following

I have 2 columns of data - I want to be able to use data validation on the first column to select its contents......then based on the results of the first column contents, use data validation on the second column......however there is a way to have the selection choices of the second coloum change depending on the results of the first column.

I'm sure this makes little sense but assume the following

Column A contains data validation list of countries
Column B contains Capital Cities of countries

I'm sure I have seen a way to select for example France in column A and then the only choice for column B would be 'Paris'

I think it may have used Index but its been a while.

Is anyone familiar with this?

regards

Md1
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,
take a look at this "famous" thread
(the link is already pointed to the "most relevant post")

http://www.mrexcel.com/board2/viewt...=0&postorder=asc&highlight=cascading&start=26

for a technique using comboboxes
http://www.mrexcel.com/board2/viewtopic.php?t=152281&start=5

see also this explanation
http://www.contextures.com/xlDataVal02.html

and
http://www.mrexcel.com/board2/viewtopic.php?t=15030&highlight=
feel free to send an email (no PM)
you'll get three files with examples

subject of email
cascading comboboxes

kind regards,
Erik
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,711
Messages
5,855,264
Members
431,717
Latest member
Ibyb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top