Complicated Lookup - Impossible?

[barnbrat]

Hello Everyone, I am familiar w/ excel, but a definite novice w/ lookups and formulas. I am trying to create a reporting sheet from a database export. I need to sort each item by 4 possible main Environments, and 6 possible sub-Environments. Each item can belong to only 1 main environment, and possibly all 6 sub-environments. The problem is that the in the software I am exporting data from, all environments & subenvironments are stored in a single free form user entered "Environment" field. Which makes this task a nightmare, if not impossible since there would be a total of 24 possibilites to run through in every single formula. See the attached spreadsheet and hopefully all of that makes sense. Thanks in advance for any and all input! Your assistance is greatly appreciated!
Enviro example.xlsx

[Bernie Deitrick]

I would use a REALLY LOUD VOICE and force whoever maintains the entry form to change the input form to use radio buttons for Main Environment, and check boxes for sub-environments.