Categorizing Products according to flavours

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!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.