Comparing Existing Data to Create Possibilities

[ShirayukiSama97]

Hello,
I have a spreadsheet in Excel that I have created to help me with potion creation in Skyrim. I took the time to list all ingredients available in the game (including all new ingredients from the anniversary edition) and the four effects each ingredient can have. I want to create a tool where I can input up to three ingredients from a list and the output would be the resulting potion with effects. The way potion creation works is by picking at least two, up to three, ingredients and create a potion. If the ingredients share effects, it creates either a potion or poison with those effects, otherwise it is a failed potion. Essentially, I want to create a tool in Excel that will allow me to input ingredients and get the possible potions results to save potion ingredients. I have created the lists, but I'm not sure how to go about creating the tool I mentioned. I would appreciate any advice on the matter.

 

[I_know_nuffin]

Hello,
I have a spreadsheet in Excel that I have created to help me with potion creation in Skyrim. I took the time to list all ingredients available in the game (including all new ingredients from the anniversary edition) and the four effects each ingredient can have. I want to create a tool where I can input up to three ingredients from a list and the output would be the resulting potion with effects. The way potion creation works is by picking at least two, up to three, ingredients and create a potion. If the ingredients share effects, it creates either a potion or poison with those effects, otherwise it is a failed potion. Essentially, I want to create a tool in Excel that will allow me to input ingredients and get the possible potions results to save potion ingredients. I have created the lists, but I'm not sure how to go about creating the tool I mentioned. I would appreciate any advice on the matter.

If your ingredients and effects are in columns A to E then the below gives duplicated effects in O3, formulas for each cell in red, enter ingredients into cell I2 ,I3 and / or I4

Edit --- note R7 has a space entered in the cell used in the concatenate to separate words