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!
