Limit/Filter Options in Select List in Column B by Value in Column A

[MrWhite23]

I have a form I'm creating for multiple users where they will have to use a drop down list in column A to select 1 of 5 options. In Column B users will also need to select an option from the list. Column B's list is expected to grow significantly, so what I would like to do is to provide some type of drill down of options in column b based on what was selected in column A.

For instance Column A options are:
GL
NA
LA
EM
AP

Column B options look like
2015-GL-nnn
2015-GL-BBB
2015-AP-THT
2015-NA-POO

If in cell A10 for example, a user selects GL, than I need for them to only see in B10, the options:
2015-GL-nnn
2015-GL-BBB

I'm using Excel version 15.0.4693 (Office 365)

Thanks in advance.

 

[CMAnslow]

Hi There,

Please see this link. Really nice way to implement what your after.

http://www.contextures.com/xlDataVal15.html