Basically would like to do

Lookup, {Products ordered}

Double Scoop (Chocolate + Vanilla), Single Scoop (Chocolate), Triple Scoop (Chocolate, Vanilla, Mint)

Formula field {Flavour categorizing}

Chocolate, Vanilla, Chocolate, Chocolate, Vanilla, Mint

The issue is that, the Lookup field can be different products at different arrangements, but would love to have the formula field to be able to SEARCH a certain product and state its flavour of choice. like the example above!

Any help will be much appreciated!