List validation

Brendan

Board Regular
Joined
Aug 31, 2006
Messages
51
Hey guys.

Not sure how to word this properly, but I'll try my best.

I know how to validate a list, so a drop down box appears and only the options that have been defined in that name are able to be selected.

What I am now interested in is having two drop down boxes that work together.

So for example I have two lists.
In the first list I have :
Anna
Jon
Joe

Any of these names can be selected in cell A1.

In cell B1, I want it to look at cell A1 and return only specific values relating to those names.

So if we have 9 fruit in the second list.
Grapes
Apples
Bananas
Pears
Oranges
Kiwifruit
Grapefruit
Peach
Apricot

Now if I select Anna - She only likes Grapes Apples and Peaches, so I only want those items to be the only options when I select Anna in A1 from my drop down validation list.

Joe only likes Oranges, Kiwifruit, Grapefruit and Peaches, so only those items will be my options when I have selected Joes name in cell A1.

Jon likes Bananas, pears and Apricot - so when his name is selected in A1, B2 will only display his favourite fruits ..

Does this make much sense at all?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,563
Messages
5,765,123
Members
425,262
Latest member
sabry

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