Variable list depending on the value of one column

[Xenthys]

Hi everybody,

I am reaching out to you today because I am having some troubles creating a variable list that depends on the value of one cell (see attached file).

On one worksheet, I have a list of Cost Centers associated with several possible family codes (that are in the same cell, and if there is more than one possible value, then they are separated by a coma).

On another worksheet, I have a selection of those same Cost Centers that can show up in any order and that can change depending on the data that is in other Worksheets.

I have 2 questions:
1) Is it possible to do in a quick way a formula that will put in a cell in front of each cost center a list with the good possibilities (without showing the whole list because 99% of the values don't matter, people will only have to choose among 2 or 3 values max)?
2) Do I need to change the way the data is presented? for instance, separate the values in a cell if there are more than one? As I have more than 1000 cells, is there a quick way of doing this?

In the example I am giving to you, I am showing the expected outcome but am using a handmade list for each one of the Cost Centers but :
1) as I have many Cost Centers potentially I can't do it by hand
2) If the cost centers change, the list will remain and it will more than likely be the wrong list as the cost center might not have those family codes at all

Thank you so much for your help!

Xenthys

EDIT: Right file uploaded

[JohnTopley]

I don't see how your file relates to your description.

[protonLeah]

your example workbook looks nothing like the description/explanation in #1 above

[63falcondude]

Did you attach the right workbook? I don't see a "Cost Center" or a "Family Code".

That being said, to get from your Example to your Expected Outcome, all that you have to do is:

Select column E > Find & Select > Go To Special > Blanks > OK > Right-click on any of the selected cells > Delete > Entire row > OK

[Xenthys]

Sorry guys/girls, you are right

Here is the right file.

[Xenthys]

Can somebody help me? Or give me a hint of what type of formula/feature might be useful here?

Thanks