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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,186,167
Messages
5,956,336
Members
438,247
Latest member
UZev

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